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,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!