0

I want to return multiple rows from stored procedure in oracle.How will i do that ?? Can any one explain me with two scenarios

1.Select all rows in a table.

2.Select rows through depending on the arguments passed.

Im new to oracle..

ksg
  • 3,927
  • 7
  • 51
  • 97
  • Here is the answer to your question: http://stackoverflow.com/questions/101033/how-to-return-multiple-rows-from-the-stored-procedure-oracle-pl-sql – Korhan Ozturk Jan 24 '12 at 13:13

1 Answers1

0

You need to create Ref Cursor so that your procedure can return a record set (multiple rows)

Korhan Ozturk
  • 11,148
  • 6
  • 36
  • 49
  • 1
    A ref cursor isn't the only option. A pipelined (table) function can also be used to return a result set. –  Jan 24 '12 at 13:20
  • I got it through Ref Cursor,but i'm eager to know what is the concept of pipelined (table) function with simple example – ksg Jan 24 '12 at 13:59
  • http://www.akadia.com/services/ora_pipe_functions.html looks like a informative tutorial for oracle pipelined functions if you are really interested, @ksg. – Korhan Ozturk Jan 24 '12 at 14:44