APEX_JSON.WRITE_RAW

Referred from Oracle Standard Document.

APEX_JSON write unescaped JSON

write an unescaped array attribute. use the escaping write() procedures instead, if possible.

PARAMETERS

  • p_value The value to be written which can be longer than 32KB

EXAMPLE

Write an array attribute that contains JSON

 declare
  l_value apex_application_global.vc_arr2;
 begin
     l_value(1) := '{ "foo": 1,';
     l_value(2) := '"bar": { "x": 1, "y": 2 }';
     l_value(3) := '}';
     apex_json.open_array;
     apex_json.write_raw(l_value);
     apex_json.close_array;
 end;