When running a procedure using the lightening bolt icon with profiler also running, if the procedure fails (even if the exception is handled and exists gracefully), *all* editor tabs (even ones opend after this happens) becomes read only and do not allow typing.
There is also a general message at the bottom saying 'ORA-01012: not logged on'. Toad cannot be closed except through task manager. Any other way shows message (toad dialog box" "Terminate debug session and close?" however no matter what you select here, toad still does not close nor is the session released.
WORKAROUND
Run the procedure from the schema browser:
1. Go to the Schema Browser
2. Select the procedure there
3. R click and select "Execute procedure"
STATUS
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center