AUTONOMOUS_TRANSACTION

Hi All,
       I am using PRAGMA AUTONOMOUS_TRANSACTION in all my pl/sql Procedures. Are there any disadvantages or  
     performance issues for using the above in the code?

Thanks,
Cavaturu
cavaturuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BobMcCommented:
No real perfomance issue, other than perhaps committing more often than you need to.
What would concern me is how you control your transactions - the way you have it, each procedure will commit its own changes - this may well be what you want, but what happens when you hit an error condition? Which bits get rolled back?

I dont know your application design, so I cant really be more specific than 'be careful'.

The only time I use autonomous transactions is when writing logs - audit trails, debug info etc where I want to find out what was attempted, even if it fails.

HTH
Bob
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cavaturuAuthor Commented:
Thank you Bob
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.