Question

3
Replies
971
Views
srivishnu Member since 2016 28 posts
CAPGEMINI
Posted: 3 years ago
Last activity: 3 years 3 months ago
Closed

Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 9851, maximum: 4000)

Hi Team,

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.

Thanks in Advance

Regards,

Vishnu

Reporting
Moderation Team has archived post
Share this page LinkedIn