CREATE OR REPLACE FUNCTION FUNCTIONNAME
RETURN SYS_REFCURSOR IS CURSORNAME SYS_REFCURSOR;
BEGIN
OPEN CURSORNAME FOR select * from DUAL;
RETURN stock_cursor;
END;
RETURN SYS_REFCURSOR IS CURSORNAME SYS_REFCURSOR;
BEGIN
OPEN CURSORNAME FOR select * from DUAL;
RETURN stock_cursor;
END;