Autonomous Transactions…


Nothing revolutionary here. I just realized I didn’t have an article about them so I thought I’d write one:

Autonomous Transactions

I can already hear Tom Kyte groaning. He’s not the worlds biggest fan of autonomous transactions. 🙂



Author: Tim...

DBA, Developer, Author, Trainer.

3 thoughts on “Autonomous Transactions…”


    You can also state there that in 999 times out of 1000, if you find yourself “forced” to use an autonomous transaction – it likely means you have a serious data integrity issue you haven’t thought about.

    Where do people try to use them?

    o in that trigger that calls a procedure that commits (not an error logging routine). Ouch, that has to hurt when you rollback.

    o in that trigger that is getting the mutating table constraint. Ouch, that hurts *even more*

    Error logging – OK.

    Almost everything else – not OK.

  2. Tom: Thanks for the heads-up on the typo. All those years in education and I can’t spell for toffee. Who’da thunk it? 🙂

    I’ve included your comment and creditied you in the article. If you take another look you’ll see it there. Hope that’s OK!



  3. Even if you don’t like it, you have to understand it. You may inherit such systems. Plus there seems to be so many standard features that work autonomously like, for example, sequences.

Comments are closed.