soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Aug 9th, 2007

 

An autonomous transaction is used to create a seprate transaction which when commited will commit data only belongs to that transaction
Example
 PROCEDURE Proc 1
  IS
  .
  INSERT 
  UPDATE
  .
 PROCEDURE proc2
  PRAGMA
   AUTONOMOUS_TRANSACTION
   .
   INSERT 
   ....
   UPDATE
   .
  COMMIT (only DML in proc2 is commited)
END proc2;

COMMIT( remaing DML are commited)
END proc1;

senkum123

 Profile Answers by senkum123 

• Aug 12th, 2007

 

PRAGMA AUTONOMOUS_TRANSACTION is used to commit the transaction in the PL/SQL block which is inside another PL/SQL block which is on the verge of rolling back.

To make an independent transaction within a PL/SQL block