OraFAQ Forum: SQL & PL/SQL » alter character set at session level

Home » SQL & PL/SQL » SQL & PL/SQL » alter character set at session level

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alter character set at session level [message #375883]

Mon, 15 December 2008 04:18

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

Hi,
I am trying to alter character set at session level. Below are the alter statements which I tried but got ora error.

ALTER SESSION SET NLS_CHARACTERSET WE8ISO8859P15
ORA-00922: missing or invalid option

ALTER SESSION SET NLS_CHARACTERSET = WE8ISO8859P15
ORA-00922: missing or invalid option

Question -

1. Can we able to alter the NLS_CHARACTERSET at session level?
2. If yes, how to perform that?

Honestly I goggled first to find this but did not have much information.

Nav

Report message to a moderator

Re: alter character set at session level [message #375884 is a reply to message #375883]

Mon, 15 December 2008 04:19

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1. No.
2. NA

Regards
Michel

Report message to a moderator

Re: alter character set at session level [message #375889 is a reply to message #375883]

Mon, 15 December 2008 04:43

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

Incase if i need to do what needs to be done. In UNIX I did
NLS_LANG=WE8ISO8859P15

anyway i can do in SQLPLUS?

Report message to a moderator

Re: alter character set at session level [message #375892 is a reply to message #375889]

Mon, 15 December 2008 04:59

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No.

Regards
Michel

Report message to a moderator

Previous Topic:	Strange Error
Next Topic:	Merge in Oracle V/S Merge in DB2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 23:59:06 CST 2025