Modified Pl/Sql Package errors when called from map with ORA-04061 & ORA-04065
(Doc ID 1280565.1)
Last updated on AUGUST 23, 2023
Applies to:
Oracle XML Gateway - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]Information in this document applies to any platform.
Symptoms
In an 11.5.10.2 environment, after modifying a pl/sql package (created a new procedure and called that procedure in the map) the map errors when called with the follow message.
ORA-04061: existing state of has been invalidated ORA-04061: existing state of package "APPS.Custom_Pkg" has been invalidated ORA-04065: not executed, altered or dropped package "APPS.Custom_Pkg" ORA-06508: PL/SQL: could not find program unit being called: "APPS.Custom_Pkg" - ECX_ACTIONS.BIND_PROC_VARIABLES
Tried to delete/recreate the trading partner, drop/recreate the package, re-start ecx listener, but the error won't go away.
Need to know how to make the map recognize the updated package without encountering the error and without having to bounce the database.
Changes
Modified a pl/sql package that is called from a map.
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 |