创建客制化webadi集成器时，导入数据经常会发生ORA-06508: PL/SQL: Could not Find Program Unit being Called in Custom Web ADI Integrator
ORA-06508: PL/SQL:无法找到正在调用 的程序单元。
metlink上的解释是[ID 567559.1]
In this Document
Symptoms
Changes
Cause
Solution
References
This document is being delivered to you via Oracle Support’s Rapid Visibility (RaV) process, andtherefore has not been subject to an independent technical review.
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
3. Retest the issue.
References
BUG:5436732 – OHS:HR SETUP INTEGRATOR WITH CUSTOM API AND INITAL UPLOADS ERROR ORA-6508
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9954871/viewspace-1287752/ ，如需转载，请注明出处，否则将追究法律责任。
