Re: PL/SQL beginner

From: Daniel Fink <>
Date: Thu, 05 Feb 2009 13:27:50 -0600
Message-ID: <>


Before you go jumping off a mountain in frustration and humiliation....

Unfortunately, that functionality does not exist in SQL*Plus. The only options we have are EXIT or CONTINUE example below). It would really be nice if there was an option 'HALT', 'SUSPEND', 'STOP' that would stop executing the script, but not take you all the way out of sql*plus. Considering the emphasis on SQL*Developer and the 11gr1 removal of sqlplus for windows, I highly doubt Oracle will be doing any enhancements.

Daniel Fink

Daniel Fink - Oracle Performance, Diagnosis, Data Recovery and Training

Oracle Blog

Lost Data?

connect demo/demo
whenever sqlerror continue
select 'CONTINUE' from daul;
whenever sqlerror continue none
select 'CONTINUE NONE' from daul;
whenever sqlerror exit
select 'EXIT' from daul;

C:\Home\scripts\SQL>sqlplus /nolog
SQL*Plus: Release - Production on Thu Feb 5 13:20:33 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
_at_> _at_test_whenever
select 'CONTINUE' from daul
ERROR at line 1:
ORA-00942: table or view does not exist

select 'CONTINUE NONE' from daul
ERROR at line 1:
ORA-00942: table or view does not exist

select 'EXIT' from daul
ERROR at line 1:
ORA-00942: table or view does not exist

Disconnected from Oracle Database 10g Enterprise Edition Release - Pr
With the Partitioning, OLAP and Data Mining options


Robertson Lee - lerobe wrote:

> Hi,
> Oracle 10gR2
> AIX 6
> Within a SQL*Plus script I have a number of calls to PL/SQL procs.
> I want to, on failure of any of the PL/SQL scripts, drop back to the
> calling SQL*Plus script and on return not go any further...i.e do not
> call any of the other Stored Procs in the SQL*PLus script.
> Ideally I would also like to report back to the calling SQL*Plus
> script the errors from the failed PL/SQL.
> I cannot re-engineer, I just need to make what is already there work
> if it is at all possible.
> Any suggestions after you have all stopped laughing ?? !!!
> Regards and TIA
> Lee
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
> Thank You.
> ****************************************************************************
Received on Thu Feb 05 2009 - 13:27:50 CST

Original text of this message