WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; spool INITIALIZE_SYSCODE_CSH_TRANSACTION.log set feedback off set define off <!--授信状态字段--> BEGIN sys_code_pkg.delete_sys_code('CREDIT_STATUS'); sys_code_pkg.insert_sys_code('CREDIT_STATUS', '授信状态', '授信状态', '授信状态', 'ZHS', ''); sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','ENABLE','启用','ZHS',''); sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','FREZZING','审批冻结','ZHS',''); sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','DISABLE','停用','ZHS',''); sys_code_pkg.insert_sys_code_value('CREDIT_STATUS','REFUSE','审批拒绝','ZHS',''); END; / set feedback on set define on spool off exit