Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Transaction Management in PL/SQl
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 - 11:35:34 CDT