📄 autonfail2.sql
字号:
CREATE OR REPLACE PROCEDURE autonfail
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
DELETE FROM emp;
RAISE VALUE_ERROR;
COMMIT;
EXCEPTION
WHEN OTHERS THEN ROLLBACK TO out_here;
END;
/
BEGIN
SAVEPOINT out_here;
autonfail;
END;
/
/*======================================================================
| Supplement to the third edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2002 O'Reilly &
| Associates, Inc. To submit corrections or find more code samples visit
| http://www.oreilly.com/catalog/oraclep3/
*/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -