Jon Dixon yeah, I'd assume the same. The CLOBs are different, APEX_JSON seems to escape string values ("O'Brien" becomes "O\u0027Brien") resulting in a bigger CLOB, but faster print performance. Escaping string values in JSON_OBJECT_T (using e.g. apex_escape.json) improves the print performance, but the serialization (to_clob) messes up the output by adding an additional backslash ("O'Brien" becomes "O\\u0027Brien").

Hi Jon, thanks for your article! After moving an implementation of generating JSON output for ORDS from APEX_JSON to JSON_OBJECT_T, we saw that: generating the JSON itself became faster, but for some reason "printing" it to ORDS is significantly slower using JSON_OBJECT_T than it is with APEX_JSON. Out of interest, can you reproduce this behavior in your tests, or does adding "apex_util.prn ( l_json_clob, false );" take the same time, independent if the CLOB comes from JSON_OBJECT_T or APEX_JSON? BR Paul

Hi Jon, I just stumbled over your post. We were working on an MS Graph SDK for PL/SQL some time ago and put it on GitHub, could be interesting for you.