BUG with Bind Variables in Labeled Block in 10gR2

Yesterday in my course I ran into a strange BUG in Oracle Express (XE) on WIN32 and Linux 32 bit, in fact one of my students,  Ralf Spiwoks, found it:

I have tried to run a  top level anonymous block in which assigned a value to a BIND variable and got kicked out of my session with an ORA-03113.

SQL> VAR lname VARCHAR2(4)

SQL> <<my_lable>>
 BEGIN
    :lname:=’LUTZ’;
   end;
/

ERROR:
ORA-03114: not connected to ORACLE
 <<my_lable>>
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

THIS IS A BUG which exists in 10gR2.

Only top level blocks are affected by this BUG.
 After I wrapped the block into another block it worked.

Here is the workaround:

BEGIN
  <<my_lable>>
 BEGIN
 :lname:=’LUTZ’;
 END;
END;
/

PL/SQL procedure successfully completed.

 I have tested only WIN 32 and LINUX32 =>  XE and Enterprise Edition on Win32.  It has been fixed in the meentime, but I am not sure with which patch.
In EE 11gR1  it works.

This entry was posted on Tuesday, March 31st, 2009 at 9:44 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “BUG with Bind Variables in Labeled Block in 10gR2”

  1. Laurent Schneider Says:
    March 31, 2009 at 11:57 am | Reply

    I am not getting ORA-3113 but ORA-3115 and ORA-3114 with 10.2.0.4


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> var x number
    SQL>
    SQL> <<x>>
    2 begin :x :=1; end;
    3 /
    <<x>>
    *
    ERROR at line 1:
    ORA-03115: unsupported network datatype or representation

    SQL> select * from dual;
    ERROR:
    ORA-03114: not connected to ORACLE
    </code>

  2. Lutz Hartmann Says:
    March 31, 2009 at 3:54 pm | Reply

    Hi Laurent,
    could you report this bug to ORACLE.
    I do not have metalink for the moment.
    =;-)

Leave a Reply