-
Title
Error, "ORA-00933: SQL Command not properly ended", when connecting to a database -
Description
I upgraded from Toad for Oracle 11.5.1 to Toad for Oracle 11.6 and now when I connect to a database I keep getting the error:
ORA-00933: SQL Command not properly ended
When I click OK, the connection seems to go through and I continue on fine. But every connection seems to invoke this error.
-
Resolution
WORKAROUND:
1. In Toad, go to Session | New Connection and export your connections to backup the connection history.
2. Close the Connection Window and go to Utilities | Copy User Settings.
3. Select, ‘Create a clean set of user files from the base installation’ and click OK, then OK to restart Toad.
4. When Toad starts, check the ‘Save Passwords’ box (only if you had saved passwords checked last time) and then import your connections.
5. Connect and re-test the issue.