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-l