Re: PL/SQL beginner

From: Greg Norris <spikey.mcmarbles_at_gmail.com>
Date: Thu, 5 Feb 2009 11:16:15 -0600
Message-ID: <d4beff360902050916l608772e1waebbf553cc64e8df_at_mail.gmail.com>



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/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
>

-- 
"I'm too sexy for my code." - Awk Sed Fred.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 05 2009 - 11:16:15 CST

Original text of this message