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.

Report message to a moderator

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: 3212
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.

Report message to a moderator

Previous Topic: Table partitioning
Next Topic: Need help!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 07 22:35:12 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.