Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exceptions
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
![]() |
![]() |