Re: Help! How can I return a result set from a stored procedure.

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.