CUS_DEPOSIT_CALC_OVERDUE_TMP_S.sql 418 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
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