Workflow Save as to Database,Encounter error: 1004: Language is not enabled

来源:互联网 发布:淘宝店什么最好卖 编辑:程序博客网 时间:2024/06/05 08:40
Workflow Save as to Database时,报两个错误

Error1:
220: Unable to set NLS_LANGUAGE

Error2:
1004: Language is not enabled, please refers to Workflow documentation for steps on enabling a language.


原因:
环境变量NLS_LANG设置不正确,正确应为AMERICAN_AMERICA.AL32UTF8,但之前设置成了‘SIMPLIFIED CHINESE_CHINA.AL32UTF8’,

设置完之后,重启workflow builder,重新拉‘Standard’模板workflow,重新设置workflow,再save as就没问题了


注:服务器端的NLS_LANGUAGE可能和客户端查询出来的结果不一样

reference:Oracle环境变量NLS_LANG