hai friends
which time we can use progma autonomous how it works plz let me know
progma autonomous
-
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
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.
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.
Who is online
Users browsing this forum: No registered users and 1 guest