Re: Error While changing the session parameter NLS_LANG
Date: 14 Oct 2003 00:39:59 -0700
Message-ID: <a1d154f4.0310132339.14f7551c_at_posting.google.com>
amitvij78 <member43015_at_dbforums.com> wrote in message news:<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.
NLS_LANG is an environment variable (Unix) or a registry variable (Winblows)
Sybrand Bakker
Senior Oracle DBA
Received on Tue Oct 14 2003 - 09:39:59 CEST