Re: Help! How can I return a result set from a stored procedure.
Date: 1996/01/06
Message-ID: <30EEB0C7.74C9_at_ozemail.com.au>#1/1
Maruf Ahmed wrote:
>
> Hi,
> I would really appreciate help in figuring out how I can return
> a result set from a stored procedure. For eg., I have couple of
> complex queries that ultimately returns to the application
> couple of rows. Rather than writing a complex and large SQL
> query from the application I would like to call a stored
> procedure and pass the necessary parameter and get the result
> set back from the stored procedure. Another question, while I am
> at it, is can I do a outer join with a table and a cursor in a
> SP? eg, table 1 has fields SSN and Name , cursor 1 is Select
> SSN from Table2 where date = xx, is it possible to now do a
> outer join on table1.ssn = cursor1.ssn (+) ?
> Thanks a lot for any reply.
> :Maruf
You can pass cursor handles from procedural objects to calling applications in Oracle v 7.2. Then all you will 've to do is fetch from the cursor.
-- Cheers Sridhar Subramaniam Avion Consulting Services Sydney - Australia Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au Disclaimer : All opinions are truly and just mine.Received on Sat Jan 06 1996 - 00:00:00 CET