The only way is to get rid of the WHEN OTHERS THEN handlers. They're
pain.
kabilang_at_my-dejanews.com wrote:
>
> One of our functions in Oracle PL/SQL requires that it calls a coverup
> procedure. This procedure in turn calls a lot of procedures in different
> packages. Now the requirement is only if all the procedures work perfectly
> without getting into the Exception block (of the respective procedures) at
> all, we need to commit the transaction. Otherwise the transaction must be
> rolled back. Now, the problem is how to monitor whether a nested procedure
> call has been completed without getting into the Exception block. Now what
> happens is it goes to WHEN OTHERS Exception handler and then comes out
> successfully. This is against the requirement. Can anyone help me how to
> monitor whether a nested procedure call has been executed without going to
> the Exception block. I'll be thankful. Yours GK
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Sep 19 1998 - 14:39:00 CDT
