INITIALIZE_PROMPT.sql 1.27 KB
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool INITIALIZE_PROMPT.log

set feedback off
set define off
begin

sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'error.login.name_password_not_match',
                                  p_language => 'ZHS',
                                  p_description => '用户名或密码错误',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'error.login.name_password_not_match',
                                  p_language => 'US',
                                  p_description => '用户名或密码错误',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'error.login.verification_code_error',
                                  p_language => 'ZHS',
                                  p_description => '验证码错误',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'error.login.verification_code_error',
                                  p_language => 'US',
                                  p_description => '验证码错误',
                                  p_created_by => 1);
	
	
end;
/
commit;
set feedback on
set define on

spool off

exit