My Oracle Support Banner

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 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.


In an 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

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