Row set from stored procedure.

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