Home -> Usenet -> comp.databases.oracle -> Error While changing the session parameter NLS_LANG

Error While changing the session parameter NLS_LANG

From: amitvij78 <member43015_at_dbforums.com>
Date: Tue, 07 Oct 2003 09:25:54 -0400
Message-ID: <3406595.1065533154_at_dbforums.com> 







I tried executing the following query.



alter session set NLS_LANG='UTF8';



I got the following error:



ORA-00922: missing or invalid option





Can anybody tell me how to do it?





I tried the following variation.





alter session set NLS_CALENDAR='ROC Official';



got the follwoing error:



ORA-12705: invalid or unknown NLS parameter value specified





I tried



alter session set NLS_CALENDAR='Gregorian';



This was done successfully.





Please advise me how to correctly execute the first query.



--
Posted via http://dbforums.com


Received on Tue Oct 07 2003 - 15:25:54 CEST












Original text of this message