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