When does a ORA-04098 occur?

Options
- A view was attempted to be retrieved for execution and was found to be invalid
- A trigger was attempted to be retrieved for execution and was found to be invalid
- A procedure was attempted to be retrieved for execution and was found to be invalid
- A table that was queries doesn’t exist

CORRECT ANSWER : A trigger was attempted to be retrieved for execution and was found to be invalid

Discussion Board
stupid question

Questions should touch problems.
encyclopedic Questions are stupid

Marek 11-12-2020 10:13 AM

ORA-04098 error

For an ORA-04098 error, the cause might be a trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger. The options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger. You can also try running the following command to check for errors on the trigger:

SHOW ERRORS TRIGGER trigger_name;

Prajakta Pandit 02-15-2017 01:56 AM

question: when does a ORA-04098 occur?

Such a question is not a good question for a knowledge test on Oracle. In practice this situation very seldom occurs. When it occurs, any professional developer will google for the ORA error code.

Fred de Vreede 11-21-2014 10:32 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲