Devart Forums

Posted: **Wed 22 Jan 2020 11:47**

Hello,

I'm evaluating dotConnect for Oracle with EF Core 3.1. When I use a bitwise AND operator in my queries, I get the ORA-01036 or ORA-00920 exceptions.

This is my query :

Code: Select all

var kind = 1;
var thirdParties = dbContext.ThirdParties.Where(tp => (tp.Kind & kind) > 0).ToList();

I get the Devart.Data.Oracle.OracleException: 'ORA-01036: illegal variable name/number'

When I remove the variable :

Code: Select all

var thirdParties = dbContext.ThirdParties.Where(tp => (tp.Kind & 1) > 0).ToList();

I get the Devart.Data.Oracle.OracleException: 'ORA-00920: invalid relational operator'

What am I doing wrong?

Posted: **Thu 23 Jan 2020 20:25**

We have reproduced the issue and will notify you when it is fixed.

Posted: **Thu 06 Feb 2020 17:05**

Any news on this?

Posted: **Tue 11 Feb 2020 19:03**

The bug with using binary operators AND, OR in EF Core 3 is fixed. We will notify you when the new public build of dotConnect for Oracle is available for download.

Posted: **Mon 02 Mar 2020 16:20**

dotConnect for Oracle v9.11.951 is released: viewtopic.php?f=1&t=39884.

Devart Forums

ORA-01036 and ORA-00920 with bitwise AND operator

ORA-01036 and ORA-00920 with bitwise AND operator

Re: ORA-01036 and ORA-00920 with bitwise AND operator

Re: ORA-01036 and ORA-00920 with bitwise AND operator

Re: ORA-01036 and ORA-00920 with bitwise AND operator

Re: ORA-01036 and ORA-00920 with bitwise AND operator