可以使用AutoCommit方法解决。例如:CREATE OR REPLACE TRIGGER TRIGGER_NAME [BEFORE|AFTER] ACTIONON TABLE_NAMEFOR EACH ROWDECLARE PRAGMA AUTONOMOUS_TRANSACTIONBEGIN......COMMIT;END;
原文转自:http://www.ltesting.net