Re: Separate cursor for bind value assignment, is this normal

Hello Kunwar,
you can use it with RDBMS version 12.1.0.2 as well - just use a newer client (e.g. instant client) version. Here is the proof with a 11.2.0.3 database on Linux and 12.2.0.1 instant client on MacOS.

SQL*Plus: Release 12.2.0.1.0 Production on Sun Sep 23 11:26:07 2018 Copyright (c) 1982, 2017, 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

SYS_at_T11DB:137> var nNumber number=10
SYS_at_T11DB:137> select count(*) from dba_objects where object_id=:nNumber;   COUNT(*)

         1

SYS_at_T11DB:137> select sql_id, sql_fulltext from v$sql where upper(sql_fulltext) LIKE '%NNUMBER'; SQL_ID SQL_FULLTEXT

------------- --------------------------------------------------------------------------------

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> kunwar singh <krishsingh.111_at_gmail.com> hat am 21. September 2018 um 14:37 geschrieben:
>
> hi Andy,
> That is very interesting to know.  I am on 12.1.0.2 , so out of luck there. You mentioned PL/SQL in your blog , i will test it out.
> Very nice writeup!
>  
> Thanks!

--
http://www.freelists.org/webpage/oracle-l