WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; spool CUS_DEPOSIT_CALC_OVERDUE_TMP_S.log prompt prompt Creating sequence CUS_DEPOSIT_CALC_OVERDUE_TMP_S prompt ==================================== prompt whenever sqlerror continue drop sequence CUS_DEPOSIT_CALC_OVERDUE_TMP_S; whenever sqlerror exit failure rollback Create sequence CUS_DEPOSIT_CALC_OVERDUE_TMP_S; spool off exit