Question
2
Replies
298
Views
Ness Technologies
Posted: February 28, 2017
Last activity: June 29, 2017
Closed
Solved
getting here was a problem getting a list: code: 22835 SQLState: 99999 while running Report definition
Hi,
I am getting "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: 6240, maximum: 4000) " error while running the RD. although when I run the same query with the RDB-open it works fine. Can anyone please help me.
Thanks,
Madhu
***Moderator Edit: Vidyaranjan | Updated Categories***
Hi Madhu,
The error is because your trying to display some property whose size is more than 4000 bytes to char which is not possible.
On that property use some function to truncate some amount of data and display.
For example you can use substring to get the first 4000 characters.
Regards,
Shanthini Charles