Re: Problem with pl/sql script

Originally posted by andrewst
> Because of the colons:
>
> declare
> Id tblPerson.IdPerson%type;
> Name tblPerson.NamePerson%type;
> begin
> select IdPerson,NamePerson
> from tblPerson
> INTO Id,Name;
> end;

Oh, and INTO should be before FROM:

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

--
Posted via http://dbforums.com