Oracle SQL Forum
Why do we need AUTONOMOUS TRANSACTION to do commit or Rollback in EXCEPTION blocks?
Well here Autonomous has nothing to do with it. Commit n Rollback the two Oracle statements u can use inside Exception block more like we use them in #Begin Block.
Its dependent on the flow of your procedure.. But most of the cases you will see #Rollback in exception block than #Commit reason being its an error jump made into #Exception block.
Sign up for STechies