Oracle自治事务的介绍(Autonomous Transactions)PRAGMA AUTONOMOUS TRANSACTION.doc

Autonomoustransactionsallowyoutoleavethecontextofthecallingtransaction,performanindependanttransaction,andreturntothecallingtransactionwithoutaffectingit',,执行一个独立的事务,然后返回调用的事务而不会影响到调用事务的状态。自治事务和调用事务不同,只有提交的事务才会在事务见共享。ThefollowingtypesofPL/SQLblockscanbedefinedasautonomoustransactions:以下的PL/SQL代码块可以定义为自治事务。**LocalproceduresandfunctionsdefinedinaPL/***Top-,。我们创建一个测试表格,然后放入2行数据,注意数据没有提交。CREATETABLEat_test(idNUMBERNOTNULL,descriptionVARCHAR2(50NOTNULL;INSERTINTOat_test(id,descriptionVALUES(1,'Descriptionfor1';INSERTINTOat_test(id,descriptionVALUES(2,'Descriptionfor2';SELECT*FROMat_test;IDDESCRIPTION------------------------------------------------------------>Next,weinsertanother8rowsusingananonymousblockdeclaredasanautonomoustransaction,,我们使用匿名的自治事务块插入另外8行数据,同时提交。DECLAREPRAGMAAUTONOMOUS_TRANSACTION;BEGINFORiIN3..10LOOPINSERTINTOat_test(id,descriptionVALUES(i,'Descriptionfor'||i;MIT;END;/PL/*F