#811 ORA-00942: table or view does not exist

None
closed-fixed
nobody
None
5
2013-10-26
2010-07-28
No

After connecting to Oracle 11g, a simple SQL statement almost always fails in the first worksheet with 'ORA-00942: table or view does not exist', and the cursor placed directly in from of the table name. If I click the 'Describe under cursor', the table details are retrieved and displayed correctly. Trying to execute the query again results in the same error.

If I then open a second worksheet, and run 'select * from dual;', the initial SQL statement in the first worksheet executes correctly.
Or if I then change the schema from the automatically selected schema to a different one, and set the dropdown to the original schema, and then run the query, it will execute correctly.
If my first query is 'select * from dual', or 'select * from user_objects', the result is as expected, but querying a table in the schema still fails.

Tora trunk, compiled on Ubuntu Lucid with gcc 4, Qt 4, etc. Oracle Instant Client 11.2

Discussion

  • Ivan Brezina

    Ivan Brezina - 2013-10-26
    • status: open --> closed-fixed
    • Group: -->
     
  • Ivan Brezina

    Ivan Brezina - 2013-10-26

    Should be fixed in Tora 3 alpha

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks