WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;
spool INITIALIZE_SYSCODE_SEAL_NUMBER.log
set feedback off
set define off
begin
sys_code_pkg.delete_sys_code('SEAL_NUMBER');
sys_code_pkg.insert_sys_code('SEAL_NUMBER', '文书部数', '文书部数', '文书部数', 'ZHS', '');
sys_code_pkg.update_sys_code('SEAL_NUMBER', 'Seal Number', 'Seal Number', 'Seal Number', 'US', '');
sys_code_pkg.insert_sys_code_value('SEAL_NUMBER','SEAL_O_TW_NUMBER','一式两份','ZHS','');
sys_code_pkg.update_sys_code_value('SEAL_NUMBER','SEAL_O_TW_NUMBER','一式两份','US','');
sys_code_pkg.insert_sys_code_value('SEAL_NUMBER','SEAL_O_TH_NUMBER','一式三份','ZHS','');
sys_code_pkg.update_sys_code_value('SEAL_NUMBER','SEAL_O_TH_NUMBER','一式三份','US','');
sys_code_pkg.insert_sys_code_value('SEAL_NUMBER','SEAL_O_F_NUMBER','一式四份','ZHS','');
sys_code_pkg.update_sys_code_value('SEAL_NUMBER','SEAL_O_F_NUMBER','一式四份','US','');
end;
/
commit;
set feedback on
set define on
spool off
exit
-
Spencer Chang authored44a055c0