Question

1
Replies
384
Views
Lakshmi M (LakshmiM4169)
Tech mahindra

Tech mahindra
IN
LakshmiM4169 Member since 2015 1 post
Tech mahindra
Posted: June 11, 2019
Last activity: June 12, 2019
Posted: 11 Jun 2019 1:02 EDT
Last activity: 12 Jun 2019 8:27 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.