oracle 找不到程序单元,WebAdi使用时的ORA-06508:PL/SQL:无法找到正在调用 的程序单元 错误...

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