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,