json_util_pkg

Functions, procedures

function ref_cursor_to_json 

function ref_cursor_to_json(
    p_ref_cursor in sys_refcursor,
    p_max_rows in number:=null,
    p_skip_rows in number:=null
) return clob

generate JSON from REF Cursor

function sql_to_json 

function sql_to_json(
    p_sql in varchar2,
    p_param_names in t_str_array:=null,
    p_param_values in t_str_array:=null,
    p_max_rows in number:=null,
    p_skip_rows in number:=null
) return clob

generate JSON from SQL statement