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