| NLS problem [message #56019] |
Sun, 02 March 2003 23:57  |
vinod nauriyal-NLS
Messages: 3
Registered: March 2003
|
Junior Member |
|
|
Hi,
i am getting a very strange problem
while connecting to my database through SQL*Plus
i am getting this problem
err number is 12705 and err message "Invalid or unkwon NLS parameter value specified"
but i am able to connect to my database if i go through command prompt and run SQL*PLUS
Can anybody help me in this matter ?
With Regards
Vinod Nauriyal
|
|
|
|
| Re: NLS problem [message #56027 is a reply to message #56019] |
Mon, 03 March 2003 05:26  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
if you're running on unix, pls make sure that the NLS-Parameters you set in ur init*.ora are the same as you set for the user in .profile.
On NT it could be that the users settings have had the NLS Variables included.
The direct connection uses the parameters from init.ora and the command line will use the Session settings.
regards
Uwe
|
|
|
|
|
|
| Re: NLS problem [message #56044 is a reply to message #56019] |
Tue, 04 March 2003 00:10 |
Praveen Kumar
Messages: 21
Registered: December 2001
|
Junior Member |
|
|
MAKE THE FOLLOWING CHANGES IN THE REGISTRY IF UR
ORACKE SERVER IS IN WINNT
1.GO TO REGEDIT
2.HKEY_LOCAL_MACHINE
SOFTWARE
ORACLE
HOME0 -->NLS_LANG(KEY) =
AMERICAN_AMERICA.WE8ISO8859P1
NOTE: THE KEY VALUE MIGHT HAVE CHANGED
REGARDS
PRAVEEN
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
