Table A have two Update trigger flip-flop, before A after, in PLSQL SQL Update list A no problem, but is put in the transaction code executes the table directly in table A and trigger A deadlock, and even if the transaction only perform an Update will be in A deadlock

CodePudding user response:

How do you know what happened to a deadlock?

CodePudding user response:

What kind of trigger, a look?

CodePudding user response:

Trigger is simple update and insert in the other table

CodePudding user response:

Very strange problem, no one can solve it