From: "bullseye" <bullseye35@deletethefunnies@excite.com>
Newsgroups: comp.databases.oracle.misc
Subject: What is this error?
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <BXlc7.8790$l7.1744029@typhoon.nyc.rr.com>
Date: Thu, 09 Aug 2001 01:46:09 GMT
NNTP-Posting-Host: 24.168.55.111
X-Complaints-To: abuse@rr.com
X-Trace: typhoon.nyc.rr.com 997321569 24.168.55.111 (Wed, 08 Aug 2001 21:46:09 EDT)
NNTP-Posting-Date: Wed, 08 Aug 2001 21:46:09 EDT
Organization: Road Runner - NYC


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?