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!

1 Answer 1


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:

  • Adding a little bit of explanation on this answer would provide some helpful context.
    – RLF
    Oct 22, 2014 at 22:16
  • 1
    Added explanation/context. Oct 22, 2014 at 23:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.