progma autonomous

[ramasrith]

hai friends

which time we can use progma autonomous how it works plz let me know

[siva sankar]

Hi,


We have two procedures like proc1 ,proc2
and proc1 having some DML operations after that we are calling second procedure name as proc2 and proc2 also having some DML operations then '<b>commit</b>' statement.
So here commit the proc1 also.
So i don't want to commit the proc1.Inorder to avoid this situation, we are using Autonomus Pragma Transction for proc2.

If any queries please let me know.

[ramasrith]

THANK U VERY MUCH

[ushakiran]

Hi siva,
I saw ur description its gr8, i request u to throw an example on that Autonomus Pragma Transction concept.
it would be greatful and needful to me and others tooooooo.