-
Title
"Existing state of packages of been discarded" error when trying to execute call -
Description
1. Create a function that calls a package. Execute the function and it works.
2. Open the package and make a change then compile. Compile is successful.
3. Go back into the function and try to execute the call again. User gets the following errors: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "YOUR PACKAGE NAME" has been invalidated ORA-04065: not executed, altered or dropped package body "YOUR PACKAGE NAME" ORA-06508: PL/SQL: could not find program unit being called:
4. Turning the DBMS Output off and on again.
5. Run the function again and the call is successful. -
Resolution
Issue happens when following the same steps in Oracle SQL Plus without Toad involved, therefore this is an issue with the Oracle environment. Please contact your DBA or Oracle for support.