Hi
Thanks for the precision. It always got me confused as to when use or not
use the colon.
Now it's clear.
Thanks
--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS site in french language)
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message de
news: jlbdmu80tqfe14i3j52875ifvubel8vu1i_at_4ax.com...
> On Fri, 23 Aug 2002 16:37:05 -0400, "Syltrem"
> <syltremzulu_at_videotron.ca> wrote:
>
> >declare
> > STATUS number;
> >begin
> > RENCS_ARC.ARCHIVE('GL_POSTINGS', 'A_GL_POSTINGS', '6', 36, :STATUS);
> >END;
> >/
> >
> >SP2-0552: Bind variable "STATUS" not declared.
> >
> >???
> >
> >I don't get it.
> >
> >Isn't the STATUS variable I declare, a bind variable?
> >
> >Confused.
> >
> >Thanks for helping
>
> You use :<variable name>
> if you have declared the variable *outside* your anonymous block with
> the sql*plus VARIABLE command. In that case it is considered a bind
> variable
> However, as status is declared *inside* your anonymous block, you
> don't need the colon
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Aug 23 2002 - 22:02:43 CDT
