Returns the temporary CLOB
that you created with INITIALIZE_CLOB_OUTPUT
.
Syntax
function get_clob_output return clob;
Example
This example configures APEX_JSON
for CLOB
output, generate JSON
, print the CLOB
with DBMS_OUTPUT
, and finally free the CLOB
.
BEGIN apex_json.initialize_clob_output; apex_json.open_object; apex_json.write('hello', 'world'); apex_json.close_object; dbms_output.put_line(apex_json.get_clob_output); apex_json.free_output; END;
Parent topic: APEX_JSON