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!

JSON ORA-06502: PL/SQL: numeric or value error

user5108636May 13 2020 — edited May 14 2020

Hi All,

Using Oracle Database 18c. I am trying to generate JSON output and get this error ORA-06502: PL/SQL: numeric or value error. It works fine for smaller JSON output less than 4000 bytes

I have a DB package containing the below code. The p_result_xml variable is defined as a CLOB.

Refer to the thread below for more about the code

JSON ORA-02000: missing ) error in PLSQL

Added on May 13 2020

3 comments

1,642 views