Chanage the dynamiclly nls_lang

[gharbi]

I translate an application from french (NLS_LANG1 : french_france.WE8ISO8859P1) to arab (NLS_LANG2 : arabic_tunisia.AR8MSWIN1256). I have to change dynamically the NLS_LANG to run my application into arab or french.

[dknight]

The database can only have one character set. If you are running on one database, you should use the UTF-8 character set.

Good luck.

[tamilselvan]

ALTER SESSION can be used to dynamically change the NLS_LANG parameter value.

[dknight]

Is it possible to use the ALTER SESSION command when the character sets are absolutely different?

Thanks in advance.