What is autonomous transaction in Oracle ?

joybanerjee
Profile Answers by joybanerjee Questions by joybanerjee
Dec 4th, 2007
1
3987

Questions by joybanerjee answers by joybanerjee

Showing Answers 1 - 1 of 1 Answers

soorajsk_84
Profile Answers by soorajsk_84 Questions by soorajsk_84

Dec 18th, 2007

autonomous transaction are independent transaction

ex
CREATE OR REPLACE PROCEDURE a1
AS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO table1 VALUES('autonomous transaction');
COMMIT;
END;

DECLARE
a NUMBER:=1;
BEGIN
INSERT INTO table1('a');
proc_a;
ROLLBACK
END;

after u execute the above code and do a select * FROM table1
you will see data autonomous transaction
Which you can independently do tcl on a block if they are autonomous