Re: PL/SQL beginner
- From: Greg Norris <spikey.mcmarbles@xxxxxxxxx>
- To: Lee.Robertson@xxxxxxxxxx
- 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@xxxxxxxxxx> 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.
Other related posts:
