HiveBrain v1.2.0
Get Started
← Back to all entries
debugModerate

Stop on error in PL/SQL developer or Oracle SQL Developer

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
errorsqlstopdeveloperoracle

Problem

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!

Solution

When you process a script in SQL Developer using the "Run Script" button (not the "Run Statement" button), it uses SQLPlus internally to execute your script. Therefore using a SQLPlus control setting which stops processing on errors should work. Try adding to the top of your script line like this:

WHENEVER SQLERROR EXIT FAILURE

Code Snippets

WHENEVER SQLERROR EXIT FAILURE

Context

StackExchange Database Administrators Q#80880, answer score: 10

Revisions (0)

No revisions yet.