WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; spool INITIALIZE_SYSCODE_CLAIM_STATUS.log set feedback off set define off begin sys_code_pkg.delete_sys_code('claim_status'); sys_code_pkg.insert_sys_code('claim_status','认领状态','认领状态','认领状态','ZHS',''); sys_code_pkg.insert_sys_code_value('claim_status','UNCLAIMED','未认领','ZHS'); sys_code_pkg.insert_sys_code_value('claim_status','CLAIMING','认领中','ZHS'); sys_code_pkg.insert_sys_code_value('claim_status','CONFIRMED','已确认','ZHS'); sys_code_pkg.insert_sys_code_value('claim_status','RETURN','认领退回','ZHS'); end; / commit; set feedback on set define on spool off exit