Re: Row set from stored procedure.

For those sort of things I usually look at asktom.oracle.com, there are quite a few examples over there. But yes I think Ref Cusros should do the trick, depending on what you want to do pipelines functions might help as well

LSC On 2/3/07, Rahul Chaudhari <rahulc_at_infonox.com> 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
>

--
http://www.freelists.org/webpage/oracle-l