Re: Error While changing the session parameter NLS_LANG

[sybrandb@yahoo.com]

amitvij78 <member43015@db forums.comwrote in message news:<3406595.1 065533154@dbfor ums.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='R OC Official';
>
got the follwoing error:
>
ORA-12705: invalid or unknown NLS parameter value specified
>
>
>
I tried
>
alter session set NLS_CALENDAR='G regorian';
>
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