Wrong Result: Pl/sql Package Not Invalidated Causes Wrong Values For Constants
(Doc ID 3068541.1)
Last updated on JANUARY 23, 2025
Applies to:
PL/SQL - Version 19.17.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
When package P1 contain constants which are used as default values in record types and package P2 uses this record type, the P2 package is not invalidated when P1 is replaced/recompiled.
If we prepend a new constant in P1 then P2 is still valid but uses the wrong value for constant in the default value of the record type.
The only way to fix this issue is to recompile P2 manually.
No issue with other user (Non-sys) with different variable name except dummy.
Changes
None.
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 |