TOUPPER ORA-00904
Posted: 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...
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();