{"ORA-00942: table or view does not exist"}

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 5
Joined: Mon 14 Mar 2011 15:58

{"ORA-00942: table or view does not exist"}

Post by FrankHealy » Wed 30 Mar 2011 16:57

I am simply trying to savechanges to a very simple part of model I get the following error

3 tables many to many

All have sequence PKS and FKs are being recognised etc...

{"An error occurred while updating the entries. See the inner exception for details."}
[System.Data.UpdateException]: {"An error occurred while updating the entries. See the inner exception for details."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: {"ORA-00942: table or view does not exist"}
Message: "An error occurred while updating the entries. See the inner exception for details."
Source: "System.Data.Entity"
StackTrace: " at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)\r\n at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)\r\n at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)\r\n at System.Data.Objects.ObjectContext.SaveChanges()\r\n at BarclaysWealth.Cart.WI.BL.ApplicationManager.SaveApplicationClient(WI_APPLICATIONCLIENT theAppClient) in C:\workwi\BarclaysWealth.Cart.WI\ApplicationManager.cs:line 121"
TargetSite: {Int32 Update(System.Data.IEntityStateManager, System.Data.IEntityAdapter)}

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

Post by AndreyR » Thu 31 Mar 2011 08:38

Are you using the Code First approach?
This error is rather generic, it can have different reasons.
Could you please provide the call stack of the inner exception?
If possible, please send us (support * devart * com, subject "EF: ORA-00942") a small test project illustrating the issue.

Posts: 2
Joined: Tue 04 Oct 2011 09:56

We are also facing same problem.

Post by anand » Tue 04 Oct 2011 16:29

We are also facing same problem. Please see the attached screen shot for exception details. If anyone has resolved this issue, please let us know.

{"ORA-06550: line 4, column 19:\nPL/SQL: ORA-00942: table or view does not exist\nORA-06550: line 4, column 1:\nPL/SQL: SQL Statement ignored\nORA-06550: line 7, column 47:\nPL/SQL: ORA-00942: table or view does not exist\nORA-06550: line 7, column 24:\nPL/SQL: SQL Statement ignored"}

Stack Trace:

at Devart.Data.Oracle.au.b(Int32 A_0)
at Devart.Data.Oracle.ax.d(Int32 A_0)
at Devart.Data.Oracle.ax.a(Int32 A_0, bf A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.e.a(CommandBehavior A_0)
at Devart.Common.Entity.ak.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.e.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 05 Oct 2011 08:06

Which Entity Framework code generation template are you using?

We recommend you to install the dbMonitor tool that performs per-component tracing of database events such as SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html

In dbMonitor you will find the SQL statement that fails to execute. Try executing the same statement (with the same parameters) using another tool (e.g., OraDeveloper Studio http://www.devart.com/dbforge/oracle/studio/) to localize the problem.

Post Reply