Toad freezes and hangs canceling / terminating an 'Execute as Script' (F5). (4270237)

When clicking "Cancel/Terminate" while a long-running query is still running, the "Please Wait" dialog appears. Toad seems to be locked up and brings up the hourglass.

In some cases it does not return and Toad needs to be shut down using Task manager. SQL and work will then be lost.

The cancel option in Toad basically sends a cancel command out to Oracle. Once that command is sent out, Toad waits for a reply from Oracle. Depending on what step in the process Oracle is at the time of cancel, it can take a long time, and we can't determine how Oracle will react. At this point it is up to how Oracle handles the command. There is not much Toad can do about the cancel in this case.

In regards to the loss of sql, Toad's SQL Recall feature shold save SQL history. In View | Options there is a setting for "Write statement to disk prior to execution". This should save the sql so that even if the run is incomplete, it will still be saved. Use F8 to bring up the SQL Recall window and general history of SQL statements.