>>
>>On the other hand, if you issue a ROLLBACK in a nested transaction, all transactions are rolled back regardless of level.
>
>If you issue a ROLLBACK on an inner nested transaction, only that transaction gets rolled back - the outer transaction(s) are not affected.

< arggh >

However, if you issue a ROLLBACK on the outer transaction, all inner transactions do get rolled back, regardless of sucessful commits