6

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!

|improve this question
7

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
|improve this answer
  • Adding a little bit of explanation on this answer would provide some helpful context. – RLF Oct 22 '14 at 22:16
  • 1
    Added explanation/context. – Joshua Huber Oct 22 '14 at 23:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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