Question

3
Replies
1540
Views
sri vishnu prabhu (srivishnu)
CAPGEMINI

CAPGEMINI
IN
srivishnu Member since 2016 28 posts
CAPGEMINI
Posted: June 13, 2017
Last activity: June 29, 2017
Posted: 13 Jun 2017 9:19 EDT
Last activity: 29 Jun 2017 12:15 EDT
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, 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.