Question
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
Hi Lakshmi, you are seeing the error because you are trying to display a property that is greater than 4000 bytes: https://community1.pega.com/community/product-support/question/getting-here-was-problem-getting-list-code-22835-sqlstate-99999