Autonomous transactions are useful for implementing actions that need to be performed independently, regardless of whether the calling transaction commits or rolls back, such as transaction logging and retry counters.只能使用自治事务吗?还有没有其它办法?
调试欢乐多
只能使用自治事务
------------------------------------------
oracle不存在嵌套事务这个说法,
而且实际并不可行
eg:
SELECT * FROM EMP WHERE ENAME = ‘FAN’;
INSERTINTO EMP(EMPNO,ENAME,SAL) VALUES(9000,’LIU’,1250);
SAVEPOINT INSERT_POINT;
INSERT INTO EMP(EMPNO,ENAME,SAL) VALUES(9001,’FU’,1300);
ROLLBACK TO INSER_POINT;
COMMIT;
但是至于使用自治事务来处理??恐怕也不行----只是个人想法。欢迎大家就此讨论。