1 CREATE PROCEDURE test_sp1( )    2     BEGIN    3     DECLARE t_error INTEGER DEFAULT 0;    4     DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;    5     6         START TRANSACTION;    7             INSERT INTO test VALUES(NULL, 'test sql 001');       8             INSERT INTO test VALUES('1', 'test sql 002');       9    10         IF t_error = 1 THEN   11             ROLLBACK;   12         ELSE   13             COMMIT;   14         END IF;   15    16     END