You can use the SET QUIET COMMIT statement: o In interactive SQL o In dynamic SQL as a statement to be dynamically executed