满意答案
bjreid
2013.11.28
采纳率:53% 等级:13
已帮助:17122人
一个简单的正常提交-异常回滚 的例子代码.
SQL> select * from test_main;
ID VALUE
---------- --------------------
2 TWO
3 THREE
1 ONE
SQL> BEGIN
2 -- 插入2条同样的数据,使主键重复,引发错误后回滚事务.
3 INSERT INTO test_main(id, value) VALUES (4, 'FOUR');
4 INSERT INTO test_main(id, value) VALUES (4, 'FOUR');
5 COMMIT;
6 EXCEPTION
7 WHEN OTHERS THEN
8 dbms_output.put_line('Error Code = ' || TO_CHAR(SQLCODE) );
9 dbms_output.put_line('Error Message = ' || SQLERRM );
10 -- 回滚事务
11 ROLLBACK;
12 END;
13 /
PL/SQL procedure successfully completed.
SQL> select * from test_main;
ID VALUE
---------- --------------------
2 TWO
3 THREE
1 ONE
SQL>
00分享举报