ORA-00952 - Table or view does not exist

ORA-00952 - Table or view does not exist

Postby Cattivik73 » Mon 10 Oct 2011 19:17

Hi,
I developed my application with oracle client 11 and oracle server 11 in code first. Now I deployed my application on the test server and I got "ORA-00952 - Table or view does not exist" at first query.
So I tried from my machine with developing environment and I get the same when I use Oracle 10 meanwhile there aren't problems when I use Oracle 11 (using the same compiled code I change only the TNS Name)
How can I resolve it?

Thank you

Claudio
Cattivik73
 
Posts: 2
Joined: Fri 30 Sep 2011 07:52

Postby Shalex » Tue 11 Oct 2011 13:47

It seems like an old schema name is used in the queries, which are generated by EF engine in the new environment. You can check this using the dbMonitor tool that performs per-component tracing of database events such as commit, rollback, SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html

You can turn off the generation of the schema name in run-time queries using the IgnoreSchemaName option of EF-provider configuration: http://www.devart.com/blogs/dotconnect/index.php/new-features-of-entity-framework-support-in-dotconnect-providers.html#Workarounds.
Shalex
Devart Team
 
Posts: 7344
Joined: Thu 14 Aug 2008 12:44

Resolved

Postby Cattivik73 » Wed 12 Oct 2011 08:07

Thank you for you response, thanks to dbMonitor I found my problem.
The problem was that the generated query have the " on every filedname and table name and so the query is case sensitive.
Thank you

Claudio
Cattivik73
 
Posts: 2
Joined: Fri 30 Sep 2011 07:52

Postby Shalex » Wed 12 Oct 2011 13:46

Shalex
Devart Team
 
Posts: 7344
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle