For a particular interface (ECC-->SAP PI-->Oracle DB).With receiver JDBC adapter, we are invoking Stored Procedures at DB for updating the interface data. We have been facing issues, where the receiver JDBC adapter says “
: ORA-04068: existing state of packages has been discarded,ORA-04061: existing state of package body "DB.PackageName.StoredProcName" has been invalidated ORA-04065: not executed, altered or dropped package body " DB.PackageName.StoredProcName" ORA-06508: PL/SQL: could not find program
unit being called: " DB.PackageName.StoredProcName" ORA-06512: at line 1.
Steps taken till now:
We have observed this issue to be intermittent. If any of you have encountered this before or can throw some light on how to get this resolved,it would be appreciated.