Posted: 13 Jun 2017 9:19 EDT Last activity: 29 Jun 2017 12:15 EDT
Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 9851, maximum: 4000)
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.
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.