unable to catch Exception

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 Received on Tue May 09 2006 - 23:13:31 CDT