Re: PL/SQL beginner
Date: Thu, 5 Feb 2009 11:16:15 -0600
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:
> 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
-- "I'm too sexy for my code." - Awk Sed Fred. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 05 2009 - 11:16:15 CST