Re: Exceptions

From: Marc Parkinson <marcpark_at_uswest.net>
Date: Mon, 15 Nov 1999 18:53:29 -0700
Message-ID: <3830B919.DC1529C2@uswest.net>

In your exception block you can have a WHEN OTHERS THEN clause. This will catch any exception raised.

Marc Parkinson

amerar_at_ci.chi.il.us wrote:

> Hello,
>
> Can I have a 'catch all' exception for the entire PL/SQL procedure? So,
> if the procedure is executing and the code says:
>
> v_fielda := TO_NUMBER(v_fieldb);
>
> And this returns an error for some reason, I can trap the code and
> display it in a file. It there such an animal as having an 'error
> routine' or 'exception' for all errors that may occur within a
> procedure?
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 15 1999 - 19:53:29 CST