Applies to:
Oracle Web Applications Desktop Integrator – Version: 11.5.10.2
This problem can occur on any platform.
Symptoms
In custom Web ADI integrator, when code changes are made to the API, then loading of rows fail
with the following error :
ORA-06508: PL/SQL: could not find program unit being called
Changes
Code changes in custom Web ADI integrator API.
Cause
This issue is addressed in Bug 5436732
This is an expected behavior. which happens when a PL/SQL package containing session state
variables is called via a web service. Once the PL/SQL package body has been modified, it gets
out of synch with the session state variables already set on sessions being handled by the Web
Server. It is the act of bouncing Apache that clears out all of these session and allows the
session state variables to be set for the new package body.
Solution
To implement the solution, please execute the following steps:
1. Run the following sql:
SQL>alter system flush shared_pool;
This clears the Shared Pool
2. Bounce the Apache server
#sh adapcctl.sh stop
#sh adapcctl.sh start