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!
searches on CLOB fields
Re: searches on CLOB fields
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.
Re: searches on CLOB fields
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!
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!
Re: searches on CLOB fields
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.
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.