Re: What is this error?

From: bullseye <bullseye35_at_deletethefunnies@excite.com>
Date: Thu, 09 Aug 2001 17:33:55 GMT
Message-ID: <7Qzc7.3537$l7.1551045@typhoon.nyc.rr.com>

"T. Schwickert" <schwickert_at_yahoo.com> wrote in message news:5fcc15a8.0108090030.752fd2_at_posting.google.com...
> Hi,
>
> perhaps you have set your 'define' to another value than &:
>
> 10:27:25 sql> set define &
> 10:28:42 sql> select &v_student_id from dual;
> Enter value for v_student_id: 123
>
> 123
> ---------
> 123
>
> 1 row selected.
>
> 10:28:52 sql> set define #
> 10:28:55 sql> select &v_student_id from dual;
> SP2-0552: Bind variable "V_STUDENT_ID" not declared.
> 10:28:57 sql>
>
> Hth
> Thomas
>

thank you for the response. I had rebuilt the database and had NOT rebooted my computer. I rebooted today and the system is recognizing the substitution variable (and I did not set anything). Received on Thu Aug 09 2001 - 12:33:55 CDT