My Oracle Support Banner

Invalidation Of Objects When An Object With Same Name As Public Synonym Created. (Doc ID 1264502.1)

Last updated on JANUARY 30, 2022

Applies to:

PL/SQL - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

After recreating a package in Schema A  which has the same name as  a public synonym a package in schema B which has the same name may become invalid.

The problem may also be exposed with the following error message seen intermittently:


ORA-6508 PL/SQL: could not find program unit being called


Changes

Problem does not occur in 10.2.0.x or in 11.2.0.1.0

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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