When running a script using F5, hitting the Esc key cancels the script’s execution
and lets me resume editing.
Unfortunately, the script keeps running in the background it seems.
This is shown on the bottom line (Running), even though the moving
blocks at the lower right corner cease, indicating activity has stopped.
After some editing Toad freezes, e.g. when I issue a commit, a rollback,
or when I hit F5 again to restart execution. It usually takes 5 to 10 minutes
for Toad to unfreeze and resume normal execution.
Is there anything I can do to prevent this behavior from occurring?
Is it something that can be fixed in Toad itself?
It’s quite a nuisance. Right now I should be deploying.
In stead I’m waiting for Toad to unfreeze.
Not my favorite way of spending an evening at home
you must understand that internal oracle structures has something called “non interuptable processes” which are not possible to interrupt (break) inside Oracle env.
however, if you wrote your sql maybe we can see problem deeper.
FYI, SQL*Plus, original Oracle tool, can be cancelled only by “ctrl+c” which in many cases leads to disconnect session.
of course many depends on way to you connect, but let us focus on TNS classic way.
