Devart Forums

Hello,

Is there a way to get a LINQ .Contains() query to translate into dbms_lob.instr in dotConnect? Or some other way to fully search on a CLOB field in dotConnect? We want to be able to search on CLOB fields, but we get an ORA-22835 Buffer too small error when doing this on a CLOB field due to the CHAR translation that occurs with dotConnect.

Thanks!

Thank you for the report. We have reproduced the issue related to the "ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion" exception. We will inform you when it is fixed.

Hi Mariial,

Can you all post in this thread when the fix makes its way into a new dotConnect build?

I appreciate everything. Thanks for taking a look into it!

Sorry for the delay. The bug related to the "ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion" error, when comparing CLOB/NCLOB columns or parameters, is fixed.
New build of dotConnect for Oracle 7.7.242 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=27136.