Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with pl/sql script

Problem with pl/sql script

From: Arek <a.klos_at_elmak.pl>
Date: Wed, 23 Jul 2003 10:21:35 +0200
Message-ID: <bflgkq$atu$1@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. Received on Wed Jul 23 2003 - 03:21:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US