Modified Pl/Sql Package errors when called from map with ORA-04061 & ORA-04065 (Doc ID 1280565.1)

Last updated on OCTOBER 24, 2016

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.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.

Changes

Modified a pl/sql package that is called from a map.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms