Re: Problem with pl/sql script

Originally posted by Arek
> 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.

Because of the colons:

declare
Id tblPerson.IdPerson%type;
Name tblPerson.NamePerson%type;
begin
select IdPerson,NamePerson
from tblPerson
INTO Id,Name;
end;

--
Posted via http://dbforums.com