Helen,
can you explain the part about the transaction not being commited.
I am not sure I understand why the commit in the original code was
not doing anything. Was it becasue the suspend was in the proc or
because of the storedprochasDML property setting(which I for sure
did not have set)?

>In fact, what I think is going on here is that your commit
> isn't actually doing anything, but you're not trapping that

possibility -

> you're committing regardless but the transaction just stays in a

prepared

> state forever...something along those lines, anyway.
>

Thanks