this is happening to a colleague running Toad for Oracle 188.8.131.52
When running a script using F5, it seems the script runner skips the first block of code,
which is to drop a table (conditionally). The next statement is a create table,
which fails because the table was not dropped.
We enabled Spool SQL to Screen, and indeed it seems the block is
read, but not executed. Nothing is shown for execution of that block.
Script runner goes right on to the next statement.
Here’s the script we’re running:
And this is the spooled SQL listing:
A colleague with the same version of Toad tried the script and it ran without issue.
So it looks like Toad is interacting with something in the environment to produce
the symptoms we’re observing.
Would you please help us to pinpoint the root cause of this problem?