1 Reply Latest reply on Nov 19, 2015 4:29 PM by thatJeffSmith-Oracle

    SQLcl: Release 4.2.0.15.295.1605 RC: Bind variable name in string is replaced with internal ID

    RJLyders

      When I run the following SQL script in SQLcl: Release 4.2.0.15.295.1605 RC . . .

       

      set serveroutput on

      set verify off

      set feedback off

       

      variable mynewvar varchar2(200)

      exec :mynewvar:='XYZ'

       

      begin

        dbms_output.enable(1000000);

        dbms_output.put_line('My new variable...":mynewvar"='||:mynewvar);

      end;

      /

       

      results in the following output. . .

       

      SQLcl: Release 4.2.0.15.295.1605 RC on Thu Nov 19 10:17:21 2015

      Copyright (c) 1982, 2015, Oracle.  All rights reserved.

       

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

      My new variable...":ZSqlDevUnIq1"=XYZ

       

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options


      Notice that the bind variable name "mynewvar" in the quoted string 'My new variable...":mynewvar"=' was replaced with an internal identifier "ZSqlDevUnIq1".