Pragma Autonomous_Transaction in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Pragma Autonomous_Transaction in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

By default oracle will not create separate transaction for the procedure.

Procedure always part of main transaction but separate transaction for procedure is not there. So commit or rollback in procedure affects transaction started in main program.

If we want to make separate transaction for the procedure then we are using pragma autonomous_transaction in declare section of the procedure. Now when we are using commit or rollback in procedure then it will affect only procedure transaction. It will not affect the main transaction.

Pragma autonomous_transaction is used in row level trigger for avoiding mutating error.

Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.

Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial

If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com

If you found this post was helpful then please don't forget to SUBSCRIBE our channel.
Subscribe us for more such posts, videos and updates.. It's Free!!

For Businesses Inquiries :- allforyoucreators@gmail.com
_____________________________________________________________________________

Join Us on Social Media -
Like our Facebook Page :- https://www.facebook.com/a4u0fficial/

PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..
CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!
BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..
ALL WE NEED IS YOUR SUPPORT ❤

=▶ Thanks for your Love and Support ◀=

Copyright ©All For You Official

Post a Comment

0 Comments