WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; spool INITIALIZE_SYSCODE_PAYMENT_FREQUENCY.log set feedback off set define off begin sys_code_pkg.delete_sys_code('PAYMENT_FREQUENCY'); sys_code_pkg.insert_sys_code('PAYMENT_FREQUENCY', '支付频率(回购)', '支付频率(回购)', '支付频率(回购)', 'ZHS', ''); sys_code_pkg.update_sys_code('PAYMENT_FREQUENCY', 'Payment_frequency', 'Payment_frequency', 'Payment_frequency', 'US', ''); sys_code_pkg.insert_sys_code_value('PAYMENT_FREQUENCY','MONTH','按月','ZHS',''); sys_code_pkg.update_sys_code_value('PAYMENT_FREQUENCY','MONTH','按月','US',''); sys_code_pkg.insert_sys_code_value('PAYMENT_FREQUENCY','IRREGULAR','不规则','ZHS',''); sys_code_pkg.update_sys_code_value('PAYMENT_FREQUENCY','IRREGULAR','不规则','US',''); end; / commit; set feedback on set define on spool off exit