ORA-00904 invalid identifier

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

ORA-00904 invalid identifier

Post by Wetrix » Wed 17 Mar 2010 12:14

Hello.

I am currently using dotConnect version 5.0.22.0 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 5.0.22.0 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

Dave

AndreyR
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