PRAGMA EXCEPTION_INIT Masks ORA-4068 and Package is not Re-Instantiated
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version 188.8.131.52 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Apr-2013***
A PL/SQL package declares a user defined exception using PRAGMA EXCEPTION_INIT for ORA-6508. When this error occurs a second user defined exception is raised which appears to mask the underlying ORA-4068 error which accompanies the ORA-6508 error. This has the effect of preventing the Package from being re-instantiated in the session even though the underlying cause of the ORA-6508 error (an invalid dependent) is resolved.
This code example demonstrates the issue (run the code in order 1 to 5):
1. Session 1
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms