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

Last updated on APRIL 06, 2023

Applies to:

Symptoms

When bind variables are used within the <ORACLE></ORACLE> tags, the following runtime error can occur:

 
Steps to reproduce :

1. Create a procedure test with the following code:
   
   create or replace procedure test (p1 IN varchar2) as
   begin
     null;
   end;
    
2. Create a dynamic page with the following code: 
   
   ORACLE>
   begin
     test(:b1);
   end;
   </ORACLE>
   
   
3.  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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.