Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 9851, maximum: 4000)
Hi Team,
When we are running report definition we are getting below error
** An error occurred on executing the query for the report definition - There was a problem getting a list: code: 22835 SQLState: 99999 Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 9851, maximum: 4000).
Recently we have done DB changes for two properties
1) Data type from Varchar2(4000) to CLOB.
2) Increased length from Varchar2(256) to Varchar2(1000).
Because of db changes this issue getting? Please help me how to resolve this issue.
Thanks in Advance
Regards,
Vishnu
Pegasystems Inc.
IN
Hi SriVishnu,
Can you please let us know what is the Pega Version and what is the DB you are using?
EPAM Systems
HK
Hi Vishnu,
The reason for this issue most probably can be the first DB change you have done. Somewhere you use " SELECT TO_CHAR" query on this column but SQL can return maximum 4000 bytes for a (VAR) CHAR datatype.So try to substring on CLOB before convert.
Thanks,
Chathurika
