RE: PL/SQL beginner
Date: Thu, 5 Feb 2009 18:38:11 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F815216E76_at_sunmsx01.Corp.Acxiom.net>
Hi Greg
Yes, I have tried that but it doesn't seem to catch it I will take another look tomorrow, its been a long day and I have just picked this up late afternoon !!
Thanks
From: Greg Norris [mailto:spikey.mcmarbles_at_gmail.com]
Sent: 05 February 2009 17:16
To: Robertson Lee - lerobe
Cc: oracle-l
Subject: Re: PL/SQL beginner
Assuming that the PL/SQL blocks aren't gratuitously suppressing errors
(i.e. when others then null), the whenever sqlerror
<http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12052.
htm#SQPUG134> command should more-or-less match your requirements.
On Thu, Feb 5, 2009 at 11:08 AM, Robertson Lee - lerobe
<Lee.Robertson_at_acxiom.com> wrote:
Hi,
Oracle 10gR2 AIX 6 Within a SQL*Plus script I have a number of calls to PL/SQLprocs.
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
-- "I'm too sexy for my code." - Awk Sed Fred. ************************************************************************* 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-lReceived on Thu Feb 05 2009 - 12:38:11 CST