Home » SQL & PL/SQL » SQL & PL/SQL » NLS_LANG and ORA-00922
NLS_LANG and ORA-00922 [message #376546] Wed, 17 December 2008 14:27 Go to next message
ramtin
Messages: 37
Registered: November 2008
Member
Hi all,

I am trying to run following command in SQL*PLUS and get error.

SQL> alter session set NLS_LANG="CANADIAN FRENCH_CANADA.UTF8";
alter session set NLS_LANG="CANADIAN FRENCH_CANADA.UTF8"
*
ERROR at line 1:
ORA-00922: missing or invalid option

Please advice.

Thank you in advance.
Re: NLS_LANG and ORA-00922 [message #376547 is a reply to message #376546] Wed, 17 December 2008 14:36 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
NLS_LANG is not a session parameter, it's a environment variable

You can only set NLS_LANGUAGE or NLS_TERRITORY, etc... with alter session.

Have a look at the documentation search page for such stuff.
Previous Topic: Table partitioning
Next Topic: Need help!!!
Goto Forum:
  


Current Time: Sat Dec 03 16:25:40 CST 2016

Total time taken to generate the page: 0.04243 seconds