This discussion is archived
1 Reply Latest reply: Dec 11, 2012 9:23 AM by Jim Smith RSS

Oracle Ref cursor- fetching

979165 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points