TOAD hangs when running certain queries from Editor using F5 or F9. The same problem doesn't occur when running the query in SQL*Plus or SQL Developer.
Example of a query that hangs:
RESOLUTION1:
Change the OCI Buffer value.
1. Go to menu View | Toad Options | Oracle | General.
2. Adjust the OCI Buffer until you find a value where the query no longer hangs.
RESOLUTION2:
Perform a Toad reset.
NOTE: Make sure to back up your Toad Authorization Key and Site Message. You can get this from the Toad Help menu | Licensing or from your own records.
1) Fully Exit Toad.
2) Go to:
XP: C:\Documents and Settings\<your_user>\Application Data\Quest Software\Toad for Oracle\10.x\
Vista / 7: C:\Users\<your_user>\AppData\Roaming\Quest Software\Toad for Oracle\10.x\
(Where X is the specific version installed).
3) Backup the CONNECTIONS.INI, CONNECTIONPWDS.INI, ToadActions.dat and SavedSQL.dat files to a separate folder.
4) Rename the 10.x folder to 10.x_OLD.
5) Start Toad.
6) When prompted to Migrate previous Toad settings, do NOT migrate any settings (choose Clean Install).
NOTE: If not prompted to complete the Initial Toad settings, this means that the above steps did not work. Or the wrong folder was renamed. Contact Support for assistance.
7) Connect to ONE database ONLY(check the 'Save Passwords' box in the login screen if preferred), and then fully exit Toad. This will finalize all the settings.
8) Start Toad again and re-test the issue.
