hi,

I belive there is error within transaction and transaction is not committed. can you add error handling within the transaction to check if there is any.

Alternately, add test line just after commit to check if opentransactions are there. update some flag in either case to know transaction status. Hope this will narrow down to the reason.

btw, is the trigger updating the same table? if yes, what is nested triggers setting?

Seraj Alam