dbTalk Databases Forums  

Return multiple queries from stored procedures

comp.databases.oracle comp.databases.oracle


Discuss Return multiple queries from stored procedures in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Urko
 
Posts: n/a

Default Return multiple queries from stored procedures - 07-16-2004 , 03:10 AM






Hello,

I want to return multiple queries from a procedure in Oracle,
I know that o can do that with REF CURSOR. But I have a problem
I have a query that has a while loop and in each iteration a do a
SELECT query, and I don't know how to return the results from these
queries.

Please help.

Thank's in advance.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.