Bind Variables In Dynamic Pages Cause ORA-29470 Errors At Runtime (Doc ID 974342.1)

Last updated on MARCH 08, 2017

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.
Checked for relevance on 26-Aug-2015

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)

 
Steps to reproduce :

  1. Create a procedure test with the following code:

     

  2. Run the dynamic page

Reproducibility :

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms