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

From: Dragutin Jastrebic <orahawk_at_gmail.com>
Date: Mon, 8 Oct 2018 20:18:06 +0200
Message-ID: <CANGCQw=iQfu_QOUfAGvfCJz8JGDg8JYeVOhfh-gXovvn_fzVoA_at_mail.gmail.com>



>
> Hello
> In this old thread=>
>
> https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:113012348062
> Tom Kyte explained
> ==>
> .... in sqlplus the exec :x := &x will be parsed each time,
> those will be unavoidable (sqlplus is not a programming environment, it is
> just a simple command line tool)
> Yes, I wish sqlplus had a way to initialize a bind variable -- it would be
> nice.
> <===
> So possibly that it was event a design choice of Oracle development team,
> since sqlplus was more seen a command line tool, not a programming tool.
> Dragutin
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 08 2018 - 20:18:06 CEST

Original text of this message