Home » SQL & PL/SQL » SQL & PL/SQL » alter character set at session level
alter character set at session level [message #375883] Mon, 15 December 2008 04:18 Go to next message
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
Re: alter character set at session level [message #375884 is a reply to message #375883] Mon, 15 December 2008 04:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. No.
2. NA

Regards
Michel
Re: alter character set at session level [message #375889 is a reply to message #375883] Mon, 15 December 2008 04:43 Go to previous messageGo to next message
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?
Re: alter character set at session level [message #375892 is a reply to message #375889] Mon, 15 December 2008 04:59 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Previous Topic: Strange Error
Next Topic: Merge in Oracle V/S Merge in DB2
Goto Forum:
  


Current Time: Fri Dec 09 19:22:25 CST 2016

Total time taken to generate the page: 0.12662 seconds