Row set from stored procedure. - oracle-l - FreeLists

Row set from stored procedure.

From: "Rahul Chaudhari" <rahulc@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 3 Feb 2007 15:33:29 +0530

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

Follow-Ups:
- Re: Row set from stored procedure.
  - From: LS Cheng
- Re: Row set from stored procedure.
  - From: Phil Singer

Other related posts: