Re: PL/SQL beginner

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.

Cheers,
Daniel Fink

-- 
Daniel Fink

OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training

OptimalDBA    http://www.optimaldba.com
Oracle Blog   http://optimaldba.blogspot.com

Lost Data?    http://www.ora600.be/



test_whenever.sql
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 10.2.0.1.0 - Production on Thu Feb 5 13:20:33 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
_at_> _at_test_whenever
Connected.
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 
10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

C:\Home\scripts\SQL>



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.

> ****************************************************************************

>   




--
http://www.freelists.org/webpage/oracle-l