Re: bind variables

I checked it out. Actually I've done a lot of variable binding using dynamic sql. But is there an appropriate use for bind variables outside dynamic sql, but inside a pl/sql block? I am sure I have seen this done before. Here's a non-pl/sql example that I use, but still not what I am trying to "get at":

SET VERIFY OFF
ACCEPT arg_id PROMPT 'Enter ID: '

VARIABLE ret_val NUMBER

EXEC :ret_val := funcname(&arg_id);

/* display the value returned */
PRINT :ret_val

In article <933611833.16349.0.nnrp-02.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> There are one or two pages on my web site which
> mention bind variables in PL/SQL - go to the
> PL/SQL topic.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> kal121_at_my-deja.com wrote in message <7o4acq$lur$1_at_nnrp1.deja.com>...
> >Can someone please point me to a paper, etc. that discusses
> >bind variables and their use in sql and pl/sql? So far
> >I have not found very extensive info on what they are and
> >what they are used for, and when should I, as a programmer,
> >be using them? I know that the Oracle parser substitutes
> >bind variables into sql statements, but I am more curious
> >about how/when I can use them myself.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 12:52:25 CDT