Modified Pl/Sql Package errors when called from map with ORA-04061 & ORA-04065
(Doc ID 1280565.1)
Last updated on JULY 26, 2019
Applies to:Oracle XML Gateway - Version 18.104.22.168 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
In an 22.214.171.124 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.
Modified a pl/sql package that is called from a map.
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