Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Problem with pl/sql script
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
![]() |
![]() |