ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body "WRAPSUPP.PMM_TRANSACTIONS" does not exist ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1
It seems to me that someone is dropping your package and you'd like to find out who it is. I'd turn on auditing for this and then I'd look at the audit trail (DBA_AUDIT_TRAIL) to see who the culprit is.
AUDIT DROP PACKAGE ON WRAPSUPP.PMM_TRANSACTIONS WHENEVER SUCCESSFUL;Once you know who is dropping the package, you can take appropriate actions to reverse this course of action.
Alternatively, you can create a trigger which stops the DROP PACKAGE from occurring.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.