searches on CLOB fields

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Fiend
Posts: 12
Joined: Wed 24 Oct 2012 23:19

searches on CLOB fields

Post by Fiend » Mon 06 May 2013 14:24

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!

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: searches on CLOB fields

Post by MariiaI » Tue 07 May 2013 13:30

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.

Fiend
Posts: 12
Joined: Wed 24 Oct 2012 23:19

Re: searches on CLOB fields

Post by Fiend » Mon 20 May 2013 15:13

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!

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: searches on CLOB fields

Post by MariiaI » Tue 21 May 2013 07:45

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.

Post Reply