Re: Confused with bind variables

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 - 16:55:47 CDT