Using OracleTextFunctions on a BLOB column

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
eldar
Posts: 6
Joined: Tue 28 Jul 2015 11:05

Using OracleTextFunctions on a BLOB column

Post by eldar » Tue 28 Jul 2015 11:49

We are trying to utilize EntityFramework with dotConnect for Oracle, we have a blob column which has text index on it. There is a class named OracleTextFunctions for oracle text functions but all its methods supports string property name. You can use

Code: Select all

context.Where(t=>OracleTextFunctions.Contains(t.IndexedColumn,"Some text") > 0 )
on a string property. But Blob columns represented with Byte[] property. So you cant use that function because it has no override support for Byte[] parameter.
and if you use like :

Code: Select all

context.Where(t=>OracleTextFunctions.Contains("IndexedColumn","Some text") > 0 )
it is converted to a sql query like :

Code: Select all

.....
WHERE CONTAINS('IndexedColumn','Some text')
which has single quoted column name and results with ORA-20000 DRG-10599 "column is not indexed" error.
Is there a workaround for this except raw sql query?

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

Re: Using OracleTextFunctions on a BLOB column

Post by MariiaI » Wed 29 Jul 2015 12:41

Thank you for the report on this. We have reproduced this issue. We will investigate it more clearly and inform you about the results as soon as possible.

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

Re: Using OracleTextFunctions on a BLOB column

Post by MariiaI » Fri 21 Aug 2015 06:06

The overloads for Contains and Matches methods are added to the OracleTextFunctions class for using full-text search with the binary columns.
New build of dotConnect for Oracle 8.5.478 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=32324.

eldar
Posts: 6
Joined: Tue 28 Jul 2015 11:05

Re: Using OracleTextFunctions on a BLOB column

Post by eldar » Wed 26 Aug 2015 10:24

Thank you, Much Appreciated.

Post Reply