Modified Pl/Sql Package errors when called from map with ORA-04061 & ORA-04065
Last updated on OCTOBER 24, 2016
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.MERPEAM_MTLTXN_IN_UTIL_P" has been invalidated ORA-04065: not executed, altered or dropped package "APPS.MERPEAM_MTLTXN_IN_UTIL_P" ORA-06508: PL/SQL: could not find program unit being called: "APPS.MERPEAM_MTLTXN_IN_UTIL_P" - 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms