7

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!

RLF
14k2 gold badges35 silver badges47 bronze badges
asked Oct 22, 2014 at 21:14

1 Answer 1

10

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
answered Oct 22, 2014 at 21:26
2
  • Adding a little bit of explanation on this answer would provide some helpful context. Commented Oct 22, 2014 at 22:16
  • 1
    Added explanation/context. Commented Oct 22, 2014 at 23:19

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.