Question
JPMorgan Chase & Co.
IN
Last activity: 15 Jun 2018 6:36 EDT
getting error while trying to save 4000 characters to a DB column
Getting below exception while we are trying to save a property which is having 4000 characters.can some one help us to resolve this issue.
** ORA-01461: can bind a LONG value only for insert into a LONG column
we are using Pega 7.1.7
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
IN
Hi,
The size of input is creating this issue
You can do one thing find the column and table, and change the datatype
Say VARCHAR2 (64) to VARCHAR2 (96)
Thank You
PEG
GB
The previous comment should be right but the fact you hit the issue with 4000 Characters reminds me UDF limitation.
Try to trace it and find the SQL query.
If you find the SQL query contains pr_read_from_stream then this is an issue with UDF.
Pega uses UDF (java function on the database) and I have seen limitation to 4000 Charaters. If so exposing the property as a column fixes the issue.