ORA-00904 invalid identifier

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Tue 16 Mar 2010 13:02

ORA-00904 invalid identifier

Post by Wetrix » Wed 17 Mar 2010 12:14


I am currently using dotConnect version and I am trying up update to version 5.35.79.

When I upgrade, I am getting an error ORA-00904 Filter1_RUD_GRP_ID invalid identifier, but when I revert back to version the problem clears.

I have managed to extract the SQL that is generated by the Entity Framework procedure and there is a difference between the two different versions, even though the table structure has not changed.

I have re-created the EDMX file, but am still getting the error.

If you would like to see the SQL please let me know (I haven't posted yet as there is a fair bit of it!)

Due to business requirements, I need to upgrade to the new version, but due to this issue I can’t, as a number of my projects would be un-supportable.

Thank you


Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 18 Mar 2010 14:15

Have you tried to upgrade to the 5.60.102 Beta build?
We have made a number of different fixes in it.
The non-Beta version will be available in a week or so.

Post Reply