SQL & PL/SQL

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!

CLOB limit while dealing with JSON data in PLSQL

User_CI7SYNov 12 2021

Hi Team,
I have a PLSQL code which takes CLOB input and give CLOB output. Basically in that CLOB I send JSON and I do some calculations, append JSON arrays and then output is JSON_OBJECT_T. The problem is that it cannot handle more than 20 JSON array in the input and I get error:
SQL Error Code 40478, Error Message: ORA-40478: output value too large (maximum: 4000)\nORA-06512: at \"DISTINV.CALC_DISTINV_RANK\", line 74\nORA-06512: at \"DISTINV.CALC_DISTINV_RANK\", line 375\nORA-06512: at line 4\n",
"action":

Added on Nov 12 2021

9 comments

2,150 views

3 mentions