Re: PL/SQL beginner

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 6 Feb 2009 06:22:24 +0000
Message-ID: <7765c8970902052222u82e1d0ax4bd03ba42aa9700e_at_mail.gmail.com>

watchout for procedures that already 'handle' errors, esepcially those that handle them with "when others then null" a.k.a "forget anything happened, move along, these are not your errors" . You wouldn't think pl/sql developers used vb practices, but they do.

Niall

On Thu, Feb 5, 2009 at 9:41 PM, Robertson Lee - lerobe < Lee.Robertson_at_acxiom.com> wrote:

> Woo Hoo !!!!!!
>
> Thanks a bunch, that does exactly what I am after
>
> Virtual beer on its way mate !!
>
>
>
> ------------------------------
> *From:* Goulet, Richard [mailto:Richard.Goulet_at_parexel.com]
> *Sent:* 05 February 2009 20:53
> *To:* Robertson Lee - lerobe; oracle-l
> *Subject:* RE: PL/SQL beginner
>
> Lee,
>
> It may be possible, but then it could also backfire so trail is
> necessary, but you could try:
>
> set serverout on size unlimited
> begin
> <procedure1>;
> <procedure2>;
> exception
> when others then dbms_output.put_line(sqlerrm);
> end;
> /
>
> This should allow the procedures to run one at a time in serial, but if an
> error occurs the pl/sql block will catch it, report the error, and then exit
> back to sqlplus gracefully.
>
>
> *Dick Goulet***
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Robertson Lee - lerobe
> *Sent:* Thursday, February 05, 2009 12:08 PM
> *To:* oracle-l
> *Subject:* PL/SQL beginner
>
> 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.
> ****************************************************************************
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Fri Feb 06 2009 - 00:22:24 CST