Home > IT Answers > Development > ORA-04098: trigger Trigger Name is invalid and failed re-validation
Pitreab
0 pts.
 ORA-04098: trigger Trigger Name is invalid and failed re-validation
Development, Oracle
Hi, I compiled the trigger in DB and tested it thru online application checkout. It worked fine. However, latter, users received an error in production environment as "ORA-04098: trigger <Trigger Name> is invalid and failed re-validation". Is it possible that compiled trigger object go invalid at runtime because of some reasons ? Kindly let me know. If ans is yes, What would be the reasons triggers go invalid run time ? Thanks and Regards, Ashutosh

Software/Hardware used:
ASKED: September 16, 2005  12:56 PM
UPDATED: September 28, 2005  10:23 AM
RELATED QUESTIONS
Answer Wiki:
Any PL/SQL object can go invalid if something it references was modified. For example an undelaying table or view was dropped/recreated, altered or called PL/SQL package was recompiled. Ken
Last Wiki Answer Submitted:  September 16, 2005  3:03 pm  by  Bozzo999   0 pts.
All Answer Wiki Contributors:  Bozzo999   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

A column or table was modified after your first test. Recompile the trigger that you can get the error message.

Good Luck,
Josir

JosirGomes
 0 pts.
 

Posted on behalf of Don L.

If you use CRTDUPOBJ or RSTOBJ/RSTLIB to install your trigger the trigger becomes inoperative. It will need to be dropped and created again.

Margaret Rouse
 225 pts.