ORA-01461 can bind a long value only for insert in a LONG column
When the user tries to enter more than 4000 characters they are unable to save into Database.
User has changed the data type from varchar to CLOB but still user is facing the error.
pyCommitError: ORA-01461-can bind a long value only for insert into a LONG column
Steps to Reproduce
1. Create a property with data type as a varchar(2000) and property type is text area.
2. Try to enter more than 4000 characters into the same field.
3. Try to save it in Orcale DB.
4. Change the data type from Varchar to CLOB. Still user will not able to save it.
Support for CLOB is not available in Pega 7.1.9.
CLOB support is backported to Pega 7.1.9.
Apply HFix-33613, HFix-33066, and HFix-32457.
0% found this useful