I want to write a piece of code in an Oracle Stored Procedure in which I have defined an explicit cursor and I want to translate it in a generic SYS_REFCURSOR.

I want to avoid to define any specific object-type based on the sql of the explicit cursor.

Thank you in advance.

The code should be:

*create or replace procedure TransformExplicitCursor(out_sysrefcursor out sys_refcursor) is
begin
DECLARE
CURSOR lc_explicit_cursor IS SELECT …./*here a complex select */

— todo something in order to obtain a sys_refcursor from lc_explicit_cursor
end TransformCursor;*