This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Oct 22, 2010 6:08 AM by DataBoy RSS

What is Alternative for REFCURSOR ?

DataBoy Newbie
Currently Being Moderated
What is the best of returning result set without using REF CURSORS.

PROCEDURE GET_emp_details(P_emp_id NUMBER,
P_RESULT_SET OUT SYS_REFCURSOR)

IS
BEGIN
OPEN P_RESULT_SET FOR
SELECT * from emp;
END;

Thank you for looking into my post. Thanks for all your help in advance.
1 2 Previous Next

Legend

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