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

最新推荐文章于 2024-07-25 08:45:00 发布

转载最新推荐文章于 2024-07-25 08:45:00 发布 · 1.4k 阅读

本文介绍了解决在使用定制WebADI集成器时遇到的ORA-06508错误的方法。此错误通常发生在对API进行代码更改后加载数据时。文章详细解释了错误产生的原因，并提供了一个解决方案，包括刷新共享池和重启Apache服务器。

创建客制化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