Re: Dumb Q but I need to Know

If you are trying to retrieve data within stored procedure you have to put them in some local variables
i.e.
declare

    l_a type1;
    l_b type2;
begin

select a,b
INTO l_a, l_b
from t
where a>1;

end

Jovan

IIFThen <msessions_at_aldensys.com> wrote in message news:SkcG3.20223$eJ2.179183_at_news1.mia...
> I'm trying to write a simple select query within an Oracle stored
procedure
> using the following syntax:
>
> select * from <tablename> where <condition statement>
>
> It's compiling with errors. How do I rectify this for Oracle SP. I guess
> I've been with MS SQL Server SP way of doing things. Can anyone out there
> help me out. Thank you.
> --
> IIFThen
>
>
Received on Thu Sep 23 1999 - 06:57:57 CEST