ORACLE EBS 中初始化环境出错ORA-06502

Question

执行这个时：fnd_global.apps_initialize(user_id => 2714, resp_id => 50877, resp_appl_id => 20004);
ORA-06502:PL/SQL:numeric or value error:character string buffer too small has been detected in fnd_global.set_nls

希望大神帮忙解决。win8系统下的oracle 10g

Answer 1

试试
l_icx_val := fnd_profile.value( 'ICX_DATE_FORMAT_MASK');
IF l_icx_val IS NOT NULL
THEN
execute immediate 'alter session set nls_date_format = ''' || l_icx_val || '''';
END IF;追问

多谢了，但是现在测试不了了，比较着急，昨天已经把系统重装了，win8用着不太好，顺便换掉了

本回答被网友采纳

Answer 2

从提示信息看是你某栏位的数值类型不对！