qq_39665357的博客

原创 oracle存储过程的独立事务

CREATE OR REPLACE PROCEDURE emp_p2 AS a VARCHAR2(50); PRAGMA AUTONOMOUS_TRANSACTION; /*每次执行都会把当前存储过程独立出来,rollback不会影响主事务数据的修改*/ BEGIN SELECT e.name INTO a FROM employees e WHERE e.id = '0'; ...