Thanks for the replies.

Yes Oracle provides a unique transaction id that I can capture in underlaying triggers. This means I don't need to 'prep' the start of the transaction itself...

I also need to identify the unique transaction id for use in an auditing system.

did you manage to find an equivalent to Oracle's local_transaction_id? I can't see how the...