Problem:
SOA via dbadapter calls a parent API.
This Parent API can inturn call child APIs.
The child API was recompiled and is in a valid state at the database layer.
The DB Adapter fails with the following message:
ORA-04061: existing state of package body "APPS.XYZ" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.XYZ"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.XYZ"
Solution:
This is a caching issue.
Either recompile the package again at the database side or bounce the SOA Managed server.
No comments:
Post a Comment