Re: Row set from stored procedure.

  • From: "LS Cheng" <exriscer@xxxxxxxxx>
  • To: rahulc@xxxxxxxxxxx
  • Date: Sat, 3 Feb 2007 11:51:46 +0100

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@xxxxxxxxxxx> 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

Other related posts: