SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cursor difference (REF Cursor & Sys_Refcursor)

SeshuGiriNov 17 2010 — edited Nov 17 2010

Hi,

Is there any difference between REF Cursor and SYS_Refcursor?

I see some packages using sys_refcursor and some using REF Cursor.

Package 1 (Spec):
   PROCEDURE s_demo1 (
      ret_rset   OUT      sys_refcursor
   );


Package 2 (Spec):
TYPE cur_set IS REF CURSOR;
PROCEDURE s_test1 (out_data OUT cur_set);
PROCEDURE s_test2 (out_data OUT cur_set);

I am going through this link (http://sql-plsql.blogspot.com/2007/05/oracle-plsql-ref-cursors.html) but didn't find the answer.

This post has been answered by Karthick2003 on Nov 17 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 15 2010

Added on Nov 17 2010

8 comments

2,483 views