Bind Variable

From: GM1056 <gm1056_at_aol.com>
Date: 1997/09/29
Message-ID: <19970929201001.QAA16833@ladder02.news.aol.com>#1/1

Could anyone explain why this won't run. Thanks.

SQL>

  1  rem *********************************************************
  2  rem *     file: pls01a.sql
  3  rem *     desc: This script contains an SQL statement to
  4  rem *             select the last name and first name for a
  5  rem *             student whose ID is specified at runtime.
  6  rem *     args: none
  7  rem *  created: by     date:
  8  rem *********************************************************

  9 set echo off
 10 set verify off
 11 column slname heading "Last Name" format a20  12 column sfname heading "First Name" format a15  13 clear screen
 14 prompt Enter a student ID:
 15 accept v_studid
 16 prompt
 17 SELECT slname, sfname
 18 FROM student
 19* WHERE studid = &&v_studid;
 20 /
Bind variable "PLS01A" not declared. Received on Mon Sep 29 1997 - 00:00:00 CDT