This content has been marked as final. Show 2 replies
SQL Developer supports the SQL*Plus WHENEVER command. In its simplest form, just start your script with:
This will stop the script at the first SQL error and return a failure code. There are other options to the WHENEVER command that you can use for more sophisticated error handling, and you can have more than one WHENEVER command to change the error processing instructions for different parts of your script.
WHENEVER SQLERROR EXIT FAILURE;
This works just fine.