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!

How to close the REF CURSOR for Implicit Result Set feature as used in DBMS_SQL.RETURN_RESULT

User_M80CRFeb 1 2021

Hello Support,
Implicit Result Set using DBMS_SQL.RETURN_RESULT, how to close the REF CURSOR passed to this function?
Shown below is a snippet from User Manual where no mention of CLOSE_CURSOR function.
Is it that Oracle closes automatically because the underlying structure is Implicit Cursor and there will be no Cursor leak ever?
Oracle_Implicit_Result_Set.jpgBest Regards

This post has been answered by Solomon Yakobson on Feb 2 2021
Jump to Answer
Comments
Post Details
Added on Feb 1 2021
5 comments
1,439 views