Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Row set from stored procedure.
Rahul Chaudhari wrote:
> Hi All,
>
> How can i get multiple rows from a PL/SQL stored procedure oracle 9i.
>
> suppose if select statement in a procedures returns 10 row, then that all 10 row should be return by a procedure at a time.(Like select statement do)
>
> is't possible in oracle.
>
> can i use ref cursor in out param of procedure.
>
> Regards,
> Rahul Chaudhari
>
What you probably want is explained here:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:19481671347143
(Be sure to include the PIPELINED keyword, or you will wonder what happened to your memory)
-- Phil Singer | psinger1 at chartermi dot net PhD, OCP, and All Around Good Guy | Do the Obvious to Reply -- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 03 2007 - 18:37:20 CST
![]() |
![]() |