Error on NLS_DATE_LANGUAGE code for Traditional and Simplified Chinese
Hello,
We are editing a data model to update the date in a report for custom languages Traditional and Simplified Chinese and we are facing this error :
"ORA-12702: invalid NLS parameter string used in SQL function."
We are not sure about the syntax of the query = 'SIMPLIFIED CHINESE', 'SIMPLIFIED - CHINESE' OR 'SIMPLIFIED_CHINESE' nor about the language code to use 'RUN_DT_zhs', 'zh_CN' in these lines :
,TO_CHAR(SYSDATE, 'fmdd ','NLS_DATE_LANGUAGE=SIMPLIFIED CHINESE') || TRIM(lower(TO_CHAR(SYSDATE,'Month', 'NLS_DATE_LANGUAGE=SIMPLIFIED CHINESE'))) || TO_CHAR(SYSDATE, ' yyyy','NLS_DATE_LANGUAGE=SIMPLIFIED CHINESE') RUN_DT_zh_CN