PRAGMA EXCEPTION_INIT Masks ORA-4068 and Package is not Re-Instantiated (Doc ID 848337.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Apr-2013***


Symptoms

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

 

Cause

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