TOUPPER ORA-00904

TOUPPER ORA-00904

Postby tayllor » Thu 25 Jul 2013 22:07

Admittingly, we are using an older version 5.70. We will upgrade, but not until we know what's going on (we don't want to upgrade only to have the same issue occur).

We have 3 developers in my group. 2 of us are encountering an ORA-00904: "TOLOWER": invalid identifier on a linq query. We have similar machines and configurations. We are building a silverlight / asp app that utilizes both the EF 4.0 and direct SQL calls. We haven't made any changes to the code when building on all 3 machines. One other important note, this error only occurs when we debug with cassini. If we publish to IIS, there is no error.

We have encountered this issue repeatedly over the last couple of years. Sometimes, I'd revert any changes on my project, rebuild, then add the changes back in, and the error would go away. Any ideas what is going on?

The query...
Code: Select all
User user = context.Users
                   .Where(q => q.LOGINID.ToLower() == userName_lower))
                   .FirstOrDefault();
tayllor
 
Posts: 2
Joined: Thu 25 Jul 2013 20:55

Re: TOUPPER ORA-00904

Postby Shalex » Tue 30 Jul 2013 10:31

1. Please find the exact SQL statement which leads to ORA-00904 with the dbMonitor tool:
http://www.devart.com/dotconnect/oracle/docs/?dbmonitor.html
http://www.devart.com/dbmonitor/dbmon3.exe

2. If possible, send us a small test project with the corresponding DDL/DML script to reproduce the error in our environment.

3. Tell us the exact versions of your dotConnect for Oracle (x.xx.xxx), Oracle client (xx.x.x.x), Oracle server (xx.x.x.x).

4. If you are connecting in the OCI mode (via Oracle client), try switching to Direct Mode. And vice versa.

5. If you do not have an access to the registered version of the latest (7.8.287) build of dotConnect for Oracle, please check a workability of the trial version: http://www.devart.com/dotconnect/oracle/download.html. If your trial period is over, contact us so that we can send you an extended trial (30 days more).
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Re: TOUPPER ORA-00904

Postby tayllor » Tue 30 Jul 2013 15:47

We renewed our license and installed 7.8. The issue is resolved.
tayllor
 
Posts: 2
Joined: Thu 25 Jul 2013 20:55


Return to dotConnect for Oracle