21.21 INITIALIZE_CLOB_OUTPUT Procedure
This procedure initializes the output interface to write to a temporary CLOB. The default is to write to SYS.HTP
. If using CLOB output, you should call FREE_OUTPUT()
at the end to free the CLOB
.
Syntax
APEX_JSON.INITIALIZE_CLOB_OUTPUT (
p_dur IN PLS_INTEGER DEFAULT sys.dbms_lob.call,
p_cache IN BOOLEAN DEFAULT TRUE,
p_indent IN PLS_INTEGER DEFAULT NULL );
Parameters
Table 21-25 INITIALIZE_CLOB_OUTPUT Procedure Parameters
Parameter | Description |
---|---|
p_dur |
Duration of the temporary |
p_cache |
Specifies if the lob should be read into buffer cache or not. |
p_indent |
Indent level. Defaults to 2 if debug is turned on, 0 otherwise. |
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