You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error on NLS_DATE_LANGUAGE code for Traditional and Simplified Chinese

Received Response
22
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!