Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exceptions
Hi
try:
declare
.................. ..................
exception
when others then
..................... .....................
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
![]() |
![]() |