37.9 FREE_OUTPUT Procedure
Frees output resources. Call this procedure after process if you are using INITIALIZE_CLOB_OUTPUT
to write to a temporary CLOB
.
Syntax
free_output;
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