ORA-12899: value too large for column xyz when i transfer audit data in json format from SQL server to oracle

[Ameyy]

ORA-12899: value too large for column xyz when i transfer audit data in json format from SQL server to oracle.

I know why the error is happening. However, have to find a way to load json format data in sql server to oracle. The sql server is coming in as object data type in talend and i converted that to string and load it as varchar2. the max is 4000 bytes but this field has more than 4000 characters.

Any help is much appreciated. Thanks.

[Anonymous]

Hi

The max length is 4000 bytes or 2000 chars for type varchar2, you can't insert a string with more than 4000 characters into an varchar2 column, you may need to do:

• Change the type to clob type in DB side if allowed.
• Divide the Json string into several segments and store them in different varchar2 columns.
• Extract data from Json string and only store data in Oracle DB.

Regards

Shong