OraFAQ Forum: SQL & PL/SQL » The following error is also happening on mirror db only: ORA-12705 or ORA-12702 errors

Home » SQL & PL/SQL » SQL & PL/SQL » The following error is also happening on mirror db only: ORA-12705 or ORA-12702 errors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

The following error is also happening on mirror db only: ORA-12705 or ORA-12702 errors [message #253043]

Sat, 21 July 2007 22:25

ktanya
Messages: 10
Registered: July 2007

Junior Member

Hello.
The following error is also happening only for the KOREAN_N lang

SQL> ALTER SESSION SET NLS_SORT='KOREAN_M';
ERROR:
ORA-12705: invalid or unknown NLS parameter value specified

ORA_NLS33 is set to the correct location.

or the error

PS: ORA-12702: invalid NLS parameter string used in SQL function
when executing
SELECT state, country_code
FROM lk_states
WHERE lang_code = 'KO'
ORDER BY
country_code,
NLSSORT(state, 'NLS_SORT = KOREAN_M')

If I change NLS_SORT to any other langs, the code works fine.
Any suggestion will be very helpful.
thanks,
Tanya

Report message to a moderator