Support Article
BatchUpdateException when max length exceeds 4k
SA-46173
Summary
Severe SQL Exception and BatchUpdateException occur when extracting a text property, with values that are greater than 4K in length, to a target database.
Error Messages
ERROR - Severe SQL Exception: ORA-01461: can bind a LONG value only for insert into a LONG column
java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
Steps to Reproduce
- Create a text property.
- Enter the value that is greater than 4K in length.
- Run the BIX extract.
Root Cause
An issue in the custom application code or rules. When extracting a property with text length of 4K or greater, the target database column must be a CLOB as the varchar2 column has a 4K byte limit.
Resolution
Perform the following local-change:
- Click the gear icon besides the property name, in the extract rule, and change the type to LongText.
- Change the target database column to type CLOB.
Published December 9, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.