Exception: {"ORA-00904: \"TOLOWER\": invalid identifier"}

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hom_rcp
Posts: 10
Joined: Sun 13 Feb 2011 12:06
Location: SY

Exception: {"ORA-00904: \"TOLOWER\": invalid identifier"}

Post by hom_rcp » Tue 26 Jun 2012 11:52

I'm using Oracle - Devart Entity Model version 6.10.103.0. Working with an Oracle engine version 10.2.0.4.

The following code gives a strange exception:

Code: Select all

using (var entitie = new Gw7Model.Gw7Entities())
{
    string username = "mohd";
    var user = entitie.Employees.FirstOrDefault(p => p.Name.ToLower() == username);
}
Exception:
An error occurred while executing the command definition. See the inner exception for details.
Inner Exception:
{"ORA-00904: \"TOLOWER\": invalid identifier"}

Any help?

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: Exception: {"ORA-00904: \"TOLOWER\": invalid identifier"}

Post by Shalex » Wed 27 Jun 2012 16:13

The latest (7.0.25) version of dotConnect for Oracle works correctly, and the generated SQL (see in dbMonitor) is like the following:

Code: Select all

SELECT 
"Extent1".DEPTNO,
"Extent1".DNAME,
"Extent1".LOC
FROM SCOTT.DEPT "Extent1"
WHERE ((LOWER("Extent1".DNAME)) = :p__linq__0) AND ROWNUM <= 1
Please upgrade to 7.0.25 and notify us about the results.

Post Reply