Error 02079 when using multiple transactions
I'm locking for a long time different records. I use a transaction per lock, and on second lock, when record is already locked by another application, I sometimes have following error :
ORA-02079 no new sessions may join a committing distributed transaction
Cause: A call to UPI2BG was issued in a session for a transaction that has begun to commit in a different branch; that is, a call to UPI2EN was issued for a branch of the same transaction in another session. This can only happen when using an external transaction manager.
Anybody got an idea ?