Re: unable to catch Exception

sappi wrote:
> Hi All,
>
> I have a .sql file with declare..begin ..exception(no_data_found and
> when others).. end;
>
> In the above procedure , I am making use(invoke) of one more procedure
> which is using No_data_found exception and when_others.
>
> The problem i am am facing is ,the main procedure is not catching the
> exception as it is already dealt by the invoking(inside) procedure.
>
> I want the exception to be catched by the outside procedure so that i
> can log those errors into a table.
>
> In this case how can we catch the exception again which is already
> dealth by WHEN_OTHERS in the Inside procedure with out changing the
> inside(invoked) procedure exception(as it is used by other procedures).
>
> -sappi

Demos of exception handling in Oracle can be found in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org