469,898 Members | 1,729 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Debugging "Table Mutating" errors... 8.1.6

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
Jul 19 '05 #1
0 1992

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Nathan Benefield | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.