Explanation Of "ORA-04068: Existing State Of Packages Has Been Discarded" And "ORA-06508 PL/SQL: Could Not Find Program Unit Being Called" Errors (Doc ID 418270.1)

Last updated on JUNE 10, 2024

Applies to:

Purpose

This bulletin should help explain the reasoning for an "ORA-04068: existing state of packages has been discarded" to appear along with scenarios of when it does and does NOT appear.

Scope

Using any two schemas (with privileges to execute a procedure in another schema) the following scenarios can be run to better understand when this error may appear.

When stepping through the different scenarios it is very important to pay close attention  to which user is executing what code.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.