NLS_LANG setting in .profile - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
NLS_LANG setting in .profile

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Setting Up Profile.......Need Help Urgently	reachtokhan	UNIX for Advanced & Expert Users	13	11-06-2007 03:06 PM
Where can I read about the difference between "..profile" and ".profile"	zorrokan	UNIX for Dummies Questions & Answers	2	09-05-2007 02:35 AM
Difference between .profile and .~/.profile	maneesh mehta	SCO	3	12-14-2005 04:35 AM
changed .profile but didnt ./.profile, yet reflected changes	yls177	UNIX for Dummies Questions & Answers	4	12-05-2002 11:21 AM
Setting LIBPATH in profile	durnelln	UNIX for Dummies Questions & Answers	7	02-22-2002 12:03 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

06-22-2007

arksjd

Registered User

Join Date: Jun 2007

Posts: 1

NLS_LANG setting in .profile

Hi

In my .Profile file initially I had given
export NLS_LANG="BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1"
and later I commented it.

When I connect to sqlplus from shell prompt and query
"select * from nls_session_parameters" it gives

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE BRAZILIAN PORTUGUESE
NLS_TERRITORY BRAZIL

but when I connect to sqlplus using sqlplusw from my windows machine and
execute the same query
"select * from nls_session_parameters" it gives
PARAMETER VALUE
------------------------------ ----------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA

I would like to know why oracle is behaving differently in the above 2 instances.

Kindly help me.
regards
Rajesh.

Bookmarks

« How can i replace certain columns in the file | while loop and delay »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 03:31 PM.