SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter session

429356Feb 14 2006 — edited Feb 14 2006

Dear All,

I want to change the NLS_CHARACTERSET/ NLS_NCHAR_CHARACTERSET at the session level but I am getting errors(as given below) , though I can able to change NLS_DATE_FORMAT at session level. So is init.ora is the only option to change this setting or is there any other way.

SQL> alter session set NLS_DATE_FORMAT='YYYY-MM-DD';

Session altered.

SQL> alter session set NLS_NCHAR_CHARACTERSET='AL32UTF8';
alter session set NLS_NCHAR_CHARACTERSET='AL32UTF8'
*
ERROR at line 1:
ORA-00922: missing or invalid option

Thanks & Regards,
Sudipta

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2006

Added on Feb 14 2006

1 comment

833 views