Bind Variables In Dynamic Pages Cause ORA-29470 Errors At Runtime
(Doc ID 974342.1)
Last updated on APRIL 06, 2023
Applies to:
Portal - Version 10.1.4.0 to 11.1.1.6.0 [Release 10gR2 to FMW11g]Information in this document applies to any platform.
Symptoms
When bind variables are used within the <ORACLE></ORACLE> tags, the following runtime error can occur:
Internal error (WWC-00006)
ORA-29470: Effective userid or roles are not the same as when cursor was parsed (WWV-11230)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.1134124670 (WWC-51000)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.1134124670 (WWC-51000)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.1134124670 (WWC-51000)
ORA-29470: Effective userid or roles are not the same as when cursor was parsed (WWV-11230)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.1134124670 (WWC-51000)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.1134124670 (WWC-51000)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.1134124670 (WWC-51000)
Steps to reproduce :
- Create a procedure test with the following code:
create or replace procedure test (p1 IN varchar2) as
begin
null;
end;
- Create a dynamic page with the following code:
ORACLE>
begin
test(:b1);
end;
</ORACLE> - Run the dynamic page
Reproducibility :
- The problem doesn't occur when the bind variable is replaced by a string value.
- The problem is reproducible with an RDBMS 11g metadata repository only.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |