Support Article
CLOB: ORA-01461: can bind LONG value for insert into a LONG
SA-30314
Summary
The user wants to insert json documents into external tables (Oracle 12c) using Clob support in Pega 7.2.1. It works for small documents < 4K but fails with ORA-01461 when larger documents > 4K are saved.
Error Messages
** ORA-01461: can bind a LONG value only for insert into a LONG column"
Steps to Reproduce
Page-New Row
Property-Set Row
Call Save Row
Commit
Root Cause
Clob support was enhanced after 7.2.1 (in 7.2.2). The changes made to use the setClob() API with Clob columns for Oracle were back ported to 7.2.1.
Resolution
Apply Hfix-30370
Any Pega 7.2.1 user can install this hfix but the fix will only benefit Oracle users inserting large values into Clob columns.
Published November 22, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.