函数支持自治事务

自治事务可以在函数中定义，标识符为PRAGMA AUTONOMOUS_TRANSACTION，其余语法与函数语法相同，示例如下。

1. create table t4(a int, b int, c text);

3. CREATE OR REPLACE function autonomous_32(a int ,b int ,c text) RETURN int AS
4. DECLARE
5. PRAGMA AUTONOMOUS_TRANSACTION;
6. BEGIN
7. insert into t4 values(a, b, c);
8. return 1;
9. END;
10. /

12. CREATE OR REPLACE function autonomous_33(num1 int) RETURN int AS
13. DECLARE
14. num3 int := 220;
15. tmp int;
16. PRAGMA AUTONOMOUS_TRANSACTION;
17. BEGIN
18. num3 := num3/num1;
19. return num3;
20. EXCEPTION
21. WHEN division_by_zero THEN
22. select autonomous_32(num3, num1, sqlerrm) into tmp;
23. return 0;
24. END;
25. /

27. select autonomous_33(0);

29. select * from t4;