We are currently in a 30 days trial with Toad for Oracle. One thing we were used to with another tool was to stop script execution on error. Toad continue execution, I tried in Code Editor and also in Script Manager.
Do you know if there is an option I’ve not found in order to get this behavior ?
In our case, we would like that a script execution will stop when it will it an error (for example, syntax error, non existing tablespace on index creation,…) instead of continuing execution until the end of the script.
You should be presented with an error dialog. If you choose the Ignore actions then script execution continues. If you choose Cancel the execution is cancelled. If you run this script in the Editor using F5 you will be presented with that dialog. Click Ignore and you get a second popup for the other bad SELECT. Select Cancel and execution stops.
No, not there, but I tried in Toad's Editor because you said it also failed in the Code Editor. I see what you mean in the Script Manager. Having it proceed automatically seems like a problem.