ERPstuff - Oracle EBS Community

Posted: **Thu Jun 14, 2007 9:27 am**

hai friends

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

Posted: **Tue Jul 24, 2007 5:46 am**

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.

Posted: **Tue Oct 23, 2007 4:53 am**

THANK U VERY MUCH

Posted: **Thu Oct 25, 2007 3:21 am**

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.