JSON notation limit 4000char ORA-40459
Extracting data from Oracle 12c database through Oracle SQL Developer using XML works nicely, however I need to convert this into a JSON extracted format and is returning errors.
ORA-40459: output value too large (actual: 4084, maximum: 4000)
40459. 00000 - "output value too large (actual: %s, maximum: %s)"
*Cause: The provided JavaScript Object Notation (JSON) operator generated a
result which exceeds the maximum length specified in the RETURN
clause.
*Action: Increase the maximum size of the data type in the RETURNING clause
or use a CLOB/BLOB in the RETURNING clause.
I tested the suggested RETURNING CLOB in each statement section related to arrayagg but still return the above error.