ORA-04098: trigger Trigger Name is invalid and failed re-validation

pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JosirGomes
    A column or table was modified after your first test. Recompile the trigger that you can get the error message. Good Luck, Josir
    0 pointsBadges:
    report
  • Margaret Rouse
    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.
    3,040 pointsBadges:
    report
  • Pitreab
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/ora-04098-trigger-trigger-name-is-invalid-and-fa... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following