Re: Problem with pl/sql script

From: Anton Buijs <remove_aammbuijs_at_xs4all.nl>
Date: Wed, 23 Jul 2003 20:16:08 +0200
Message-ID: <3f1ed1a4$0$49113$e4fe514c@news.xs4all.nl>

Arek <a.klos_at_elmak.pl> schreef in berichtnieuws bflgkq$atu$1_at_nemesis.news.tpi.pl...
| Hello,
| I have 1 row in table "tblPerson".And PL/SQL Script :
|
| declare
| Id tblPerson.IdPerson%type;
| Name tblPerson.NamePerson%type;
| begin
| select IdPerson,NamePerson
| from tblPerson
| INTO :Id,:Name;
| end;
|
|
| I get back an error:
| SP-0552: Variable "Id" is not defined.
|
| Why it doesn't work ? (Oracle 8.1.7)
|
| Arek.
|

Variables must be defined first in sqlplus. And into must be before from clause.
Demo:

SQL> create table person (id number, name varchar2(15));

Table created.

SQL> insert into person values (1,'A_NAME');

1 row created.

SQL> declare
  2 id person.id%type;
  3 name person.name%type;
  4 begin
  5 select id, name
  6 into :id, :name
  7 from person;
  8 end;
  9 /
SP2-0552: Bind variable "NAME" not declared.

SQL> var id number
SQL> var name char(15)
SQL> declare

  2 id person.id%type;
  3 name person.name%type;
  4 begin
  5 select id, name
  6 into :id, :name
  7 from person;
  8 end;
  9 /

PL/SQL procedure successfully completed.

SQL> print id

        ID

---

         1

SQL> print name

NAME

---

A_NAME SQL> Received on Wed Jul 23 2003 - 13:16:08 CDT