1 Reply Latest reply: Dec 11, 2012 11:23 AM by Jim Smith RSS

    Oracle Ref cursor- fetching

    979165
      Hi.. Greetings.

      I have a refcursor (aref_seq_reftyp) with 3 rows output. Like below

      Seq_order
      1
      2
      3

      I need to assign these 3 rows in 3 different variables while fetching the cursor. For ex.
      ls_seq_order1 :=1
      ls_seq_order2 :=2
      ls_seq_order3 :=3

      Please give me an idea to implement the above.