Re: Problem with pl/sql script

"Arek" <a.klos_at_elmak.pl> wrote in message news: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.
>
>

Arek

Try

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

--
Remove the dross to contact me directly