SET AUTOCOMMIT OFF;
WHENEVER sqlERROR EXIT FAILURE ROLLBACK;

{script 1}
{script 2}
{script 3}
{script 4}
.
.
.
{script 10}

COMMIT;

DDL将在成功时隐含承诺.我们不会为DDL发出提交.您应该有一个On failure脚本来进行手动回滚.

例如：您创建两个表然后进行回滚

WHENEVER sqlERROR CONTINUE; 
DROP TABLE1; 
DROP TABLE2;