INITIALIZE_PROMPT.sql 1.27 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
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