关于自定义事物



CREATE TABLE TEST (coll NUMBER CHECK(coll>0)) ;

SET TRANSACTION NAME 'update coll';
INSERT INTO TEST VALUES(1);
INSERT INTO TEST VALUES(-1);
COMMIT COMMENT 'update coll';
select * FROM TEST ;

DECLARE
exp1 EXCEPTION ;
PRAGMA EXCEPTION_INIT(exp1,-02290);
BEGIN
INSERT INTO TEST VALUES(3);
INSERT INTO TEST VALUES(-3);
commit ;
EXCEPTION
 WHEN exp1 THEN
dbms_output.put_line('违反了约束条件 ！');
COMMIT ;
END ;

BEGIN
INSERT INTO TEST VALUES(5);
INSERT INTO TEST VALUES(-5);
COMMIT ;
END ;

INSERT INTO TEST VALUES(4);
INSERT INTO TEST VALUES(-4);
COMMIT ;

select * FROM TEST ;