Re: Transaction Management in PL/SQl

1.Create a package with a variable(Number) and assign it to zero, then if your application goes into the exception section, change it to some value,say 1; When committing, check this value. 2.Regarding your other question(passing parameters), you can use pl/sql tables. 7.3 supports lot of additional features for pl/sql tables. Hope this helps. -Kumar In article <6u0mgm$onh$1_at_nnrp1.dejanews.com>, 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
>

-----== 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 - 19:46:36 CDT