Working remotely I have to VPN into my corporate network and then connect to Oracle 9i DB via TNSNames. This morning, while using TDA v188.8.131.528 Beta I neglected to VPN back in and reconnect to the database.
I issued several queries in Editor and the Messages window indicated that they had executed successfully, but no Result Sets were generated. Only after much frustration did I realize that the Oracle connection didn’t have the “connected” symbol. [Right-click --> Reconnect] solved the problem but only after much confusion.
I am accustomed to Toad for Oracle’s functionality where the DB Connection is simply reestablished when a query is attempted. How is TDA designed to handle this?