用一个示例讲解自治事务和非自治事务的区别

• 关 键 词：

下面是个简单的测试,可以让大家更加清楚的明白自治事务和非自治事务的区别：

SQL> create table chris_test (name varchar2(200));

Table created.

SQL> create or replace procedure Autonomous_insert

2 as

3 pragma autonomous_transaction;

4 begin

5 insert into chris_test values ('Autonomous Insert!');

6 commit;

7 end;

8 /

Procedure created.

SQL> create or replace procedure Nonnomous_insert

2 as

3 begin

4 insert into chris_test values ('Nonnomous Insert!');

5 commit;

6 end;

7 /

Procedure created.

SQL> begin

2 insert into chris_test values ('Anonymous Block!');

3 Nonnomous_insert;

4 rollback;

5 end;

6 /

PL/SQL procedure successfully completed.

SQL> select * from chris_test;

NAME

------------------------------------------------

Anonymous Block!

Nonnomous Insert!

SQL> truncate table chris_test;

Table truncated.

SQL> begin

2 insert into chris_test values ('Anonymous Block!');

3 Autonomous_insert;

4 rollback;

5 end;

6 /

PL/SQL procedure successfully completed.

SQL> select * from chris_test;

NAME

----------------------------------------------

Autonomous Insert!

（责任编辑；卢兆林）

【深 度 阅 读】 相 关 文 章

• ORA-12154: TNS: 无法解析指定的连接标识符
• RMAN性能调优
• ORA-01562 和 ORA-01628 问题解决
• 详细讲解容灾技术中的数据一致性