Using OracleTextFunctions on a BLOB column

Using OracleTextFunctions on a BLOB column

Postby 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?
eldar
 
Posts: 2
Joined: Tue 28 Jul 2015 11:05

Re: Using OracleTextFunctions on a BLOB column

Postby 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

Postby 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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Using OracleTextFunctions on a BLOB column

Postby eldar » Wed 26 Aug 2015 10:24

Thank you, Much Appreciated.
eldar
 
Posts: 2
Joined: Tue 28 Jul 2015 11:05


Return to dotConnect for Oracle