Re: How can I interpert error codes returned in PLSQL procedure?

From: Paul Moore <paul.moore_at_atosorigin.com>
Date: Thu, 29 Nov 2001 12:03:49 +0100
Message-ID: <695c0uggsvdfn93ccpfev2dco1ucaq6ufi@4ax.com>

On Wed, 28 Nov 2001 19:53:00 +0100, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>having a "when others" that does not immediate re-raise the exception is almost
>certainly a BUG. You silently ignore all errors. What if someone calls your
>procedure without serveroutput on? Or calls it from a java/jdbc app (no
>dbms_output there). You will silently *fail* and they will never ever know.

And the real killer is that if you do this in a loop which then gets stuck, the DBA can't even kill your session for you! (The kill results in a session not connected error, which then gets trapped, so the loop carries on, getting another session not connected, etc etc....)

Don't laugh - someone did it to me. More than once.

Paul. Received on Thu Nov 29 2001 - 05:03:49 CST