Re: Dumb Q but I need to Know

From: Jovan Sarai <jsarai_at_tpg.au.com>
Date: Thu, 23 Sep 1999 14:57:57 +1000
Message-ID: <XuiG3.59$_E3.2776@nsw.nnrp.telstra.net>

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 Wed Sep 22 1999 - 23:57:57 CDT