ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Entity Framework error: 'ORA-00904: "SUBPROGRAM_ID": invalid identifier'.'.

839241Feb 12 2011 — edited May 26 2011

I am using the new ODAC/ODP.NET Beta with Entity Framework support. (11.2.0.2.30)

If you are trying to create a new Entity Framework model on Visual Studio 2010 you may get the following error:

An error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.EntityCommandExecutionException' occurred. The error message is: 'An error occurred while executing the command definition. See the inner exception for details.

The inner exception caught was of type 'Oracle.DataAccess.Client.OracleException', with this error message: 'ORA-00904: "SUBPROGRAM_ID": invalid identifier'.'.

This will happen when you try to connect to an Oracle "Express Edition". The view called USER_ARGUMENTS doesn't return the column called "SUBPROGRAM_ID". (the Express edition is based on 10.2.0.1, and the column called "SUBPROGRAM_ID" was added in 10.2.0.2 and higher.)

I can't find a workaround for now. I need to use Oracle Express. Anyone has a suggestion?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2011

Added on Feb 12 2011

#odp-net, #oracle

11 comments

3,464 views