Re: What is this error?

From: T. Schwickert <schwickert_at_yahoo.com>
Date: 9 Aug 2001 01:30:59 -0700
Message-ID: <5fcc15a8.0108090030.752fd2@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

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

"bullseye" <bullseye35_at_deletethefunnies@excite.com> wrote in message news:<BXlc7.8790$l7.1744029_at_typhoon.nyc.rr.com>...
> I have a select statement with this substitution variable
>
> "AND student_id = &v_student_id"
>
> rather than prompt me for the student_id when I run the script I get the
> error below:
>
> SP2-0552: Bind variable "V_STUDENT_ID" not declared.
>
> What is this error?
Received on Thu Aug 09 2001 - 03:30:59 CDT