Oracle PL/SQL: SYS_RefCursor to JSON
The procedure below receives a SYS_RefCursor as a parameter and constructs a simple JSON in Oracle 11g: procedure get_json_fnc(P_RS_i Sys_Refcursor) is P_RS SYS_REFCURSOR; L_COLS NUMBER; L_DESC DBMS_SQL.DESC_TAB; L_CURS INTEGER; …