Unable to cancel a running query when DBMS_Output polling is enabled. When enabled, Toad hangs for the period of time the script is running and the output is polling. Once the script is complete, Toad works again.
If DBMS_Output polling is disabled, the script can be halted and work can be continued in Toad.
WORKAROUND:
Do not toggle on polling for output in the DBMS output tab. Instead, fetch any existing output when the PL/SQL finishes executing.
(Toad Options | Execute/Compile | Behavior | Poll for output when detected). If there is no output upon completion, nothing will appear.
