I have only a developer's level knowledge of Oracle, though I have access to
DBA tools. Searches through the docs have not been fruitful, so I thought
I'd try here.
I am getting an error on a simple 1-row I-SQL delete statement that a
different table may be "mutating" and the transaction is then rolled-back. I
understand what this means, and have fixed "mutating" errors before.
But I cannot for the life of me trace-thru in the trigger-chain and
DRI-chain how this particular table is even being touched in THIS particular
transaction.
Is there some sort of "Trace" utility / function I can enable and view to
see what is going on "behind" this simple 1-row delete statement.... that
might tell me more-specifically where the failure is occurring in the chain
cascading (trigger and DRI) operations?
Many Thanks
DBA tools. Searches through the docs have not been fruitful, so I thought
I'd try here.
I am getting an error on a simple 1-row I-SQL delete statement that a
different table may be "mutating" and the transaction is then rolled-back. I
understand what this means, and have fixed "mutating" errors before.
But I cannot for the life of me trace-thru in the trigger-chain and
DRI-chain how this particular table is even being touched in THIS particular
transaction.
Is there some sort of "Trace" utility / function I can enable and view to
see what is going on "behind" this simple 1-row delete statement.... that
might tell me more-specifically where the failure is occurring in the chain
cascading (trigger and DRI) operations?
Many Thanks