Question

1
Replies
112
Views
LakshmiM4169 Member since 2015 1 post
Tech mahindra
Posted: June 11, 2019
Last activity: June 12, 2019
Closed

ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

I have added the CLOB column in Database table. Able to store more than 4000 bytes using CLOB data type in Oracle database table. But when i tried to pull the CLOB column table via Report definition in Pega 7.4 version getting the error.

Error:

An error occured 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: 6000, maximum: 4000) DatabaseException caused by prior exception: java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 6000, maximum: 4000) | SQL Code: 22835 | SQL

Please suggest to overcome the error
Pega Academy
Moderation Team has archived post
Share this page LinkedIn