ORA-04098: trigger is invalid and failed
Oracle Error Tips by Burleson Consulting
Question: What cause
the ORA-04098 error?
ORA-04098: trigger scott.trig1 is invalid and failed re-validation
What is the fox for the ORA-04098 error?
Answer: Oracle oerr
utility shows this about ORA-04098:
ORA-04098: trigger "string.string"
is invalid and failed re-validation
trigger was attempted to be retrieved for execution and was found to be
invalid. This also means that compilation/authorization failed for the
Action: Options are to resolve the
compilation/authorization errors, disable the trigger, or drop the trigger.
You can also try running the following show errors command to check for
errors in the trigger:
SHOW ERRORS TRIGGER trigger_name;
When you have a syntax error in a trigger, you can issue this
query to see the eact reasons why Oracle threw the ORA-04098 error:
Many users find that when using Oracle Human Resources version
11.5.9, ORA-04098 is thrown in conjunction with Frm-40735.