Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
At this time I am using TOAD to apply SQL*Plus scripts and there is an option to stop on the first error. After it I can fix the script and apply the remaining part.
Due to license issues we can't use TOAD anymore and we have a choice between Oracle SQL Developer or PL/SQL Developer. Is it possible to set such behaviour there?
For example, Aqua Data Studio just shows all errors at the end of execution, but it doesn't stop on them. Thanks!
When you process a script in SQL Developer using the "Run Script" button (not the "Run Statement" button), it uses SQL*Plus internally to execute your script. Therefore using a SQL*Plus control setting which stops processing on errors should work. Try adding to the top of your script line like this:
WHENEVER SQLERROR EXIT FAILURE
