Home » SQL & PL/SQL » SQL & PL/SQL » The following error is also happening on mirror db only: ORA-12705 or ORA-12702 errors
The following error is also happening on mirror db only: ORA-12705 or ORA-12702 errors [message #253043] Sat, 21 July 2007 22:25 Go to next message
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

Re: The following error is also happening on mirror db only:ORA-12705 or ORA-12702 errors [message #253046 is a reply to message #253043] Sat, 21 July 2007 22:43 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Based upon
http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/applocaledata.htm#i637232

I suspect the KOREAN_M require "proper" characterset support.

[Updated on: Sat, 21 July 2007 22:46] by Moderator

Report message to a moderator

Previous Topic: limit the returned size of query
Next Topic: RETRIEVING THE DATA FROM MULTIPLE TABLES
Goto Forum:
  


Current Time: Wed Dec 07 06:42:54 CST 2016

Total time taken to generate the page: 0.05629 seconds