Re: Exceptions

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Tue, 09 Nov 1999 22:38:59 GMT
Message-ID: <01bf2b13$27733d60$a504fa80@mndnet>

Hi

try:

declare

..................
..................

begin
..............
..............

exception

   when others then

    .....................
    .....................

end;

Suresh Bhat
Oracleguru
www.oracleguru.net

amerar_at_ci.chi.il.us wrote in article <80a32s$h8q$1_at_nnrp1.deja.com>...
>
>
> 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 Tue Nov 09 1999 - 16:38:59 CST