Return multiple queries from stored procedures

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Urko

    Return multiple queries from stored procedures

    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.
Working...