Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MAX_STRING_SIZE Parameter not responding to new setting

3857119Apr 9 2019 — edited May 23 2019

Hi,

I am receiving this error when trying to return a json string. I increased the size of the parameter "MAX_STRING_SIZE' to EXTENDED and am still getting the same result.

In upgrade mode I have also run utl32k.sql script.

ORA-40478: output value too large (maximum: 4000)

40478. 00000 - "output value too large (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 or BLOB in the RETURNING clause.

This post has been answered by Sven W. on Apr 23 2019

Jump to Answer

Added on Apr 9 2019

6 comments

1,788 views