Skip to Main Content

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!

Refcursor and Normal Cursor

PrafullaJan 17 2011 — edited Jan 18 2011
Hi Folks,
As per my understanding there is no performance wise difference between the normal cursor and ref cursor the only difference is that only through the help of the refcur we can return the result set to the calling env or calling procedure.
But in OTN site one of the excerpts from Tom I came across a statement that the refcursors can not be global means we can not declare the refcur in the package specification
the link is http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:14188501024541
but many times in my project we have declaree the refcursor in the package specifications also
Can any one explain me what Tom really meant by that statement or whether I am misinterpreting the statement


Any suggestions will be highly appreciated

Thanks in advance

Prafulla
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2011
Added on Jan 17 2011
19 comments
1,573 views