Re: Exceptions

From: TurkBear <johng_at_mm.com>
Date: Tue, 09 Nov 1999 21:59:41 GMT
Message-ID: <38289870.10591059@super.news-ituk.to>

You can have an exception handler for 'When Others...' that will work for all non-specified errors - check the docs on Exception Handling...

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.

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Nov 09 1999 - 15:59:41 CST