NLS settings? [message #239420] |
Tue, 22 May 2007 05:49 |
leevun
Messages: 3 Registered: February 2007 Location: Belgium - Ghent
|
Junior Member |
|
|
Hi,
I have the following problem:
I have a testserver and a local machine:
TestServer:
Windows 2000 server, IE 5 (can't update to version 7 because not compatible with windows 2000)
Local:
It's my own local develop-machine, windows XP, IE 7
Both of them run a tomcat application which connects to an oracle-DB which is the SAME database. The java-tomcat code is also a copy of each other.
The java code calls a procedure in a PL/SQL package which returns a list. As i've said before, it's exact the same situation, except the machines.
local it returns
G10000266;5;80;68;0;12;G10000267;5;80;68;0;12;G10000268;5;80;68;0;12;G10000269;5;80;68;0;12;G10000270;5;80;68;0;12;G10000271;5;80;68; 0;12;G10000272;5;80;68;0;12;G10000273;5;80;68;0;12;G10000274;5;80;68;0;12;G10000275;5;80;68;0;12;G10000276;5;80;68;0;12;G10000277;5;8 0;68;0;12;G10000278;5;80;68;0;12;G10000279;5;80;68;0;12;G10000280;5;80;68;0;12;G10000281;5;80;68;0;12;G10000282;5;80;68;0;12;G1000028 3;5;80;68;0;12;G10000284;5;80;68;0;12;G10000285;5;80;68;0;12;G10000286;5;80;68;0;12;G10000287;5;80;68;0;12;G10000288;5;80;68;0;12;G10 000289;5;80;68;0;12;G10000290;5;40;34;0;6;G10000291;5;24;20,4;0;3,6;500000433;4;100;85;0;15;500000434;4;100;85;0;15;550000445;3;63;53 ,55;0;9,45;650000432;1;74;62,9;0;11,1;
on the test server it returns:
500000433;4;100;85;0;15;500000434;4;100;85;0;15;550000445;3;63;53.55;0;9.45650000432;1;74;62.9;0;11.1;G10000266;5;80;68;0;12;G1000026 7;5;80;68;0;12;G10000268;5;80;68;0;12;G10000269;5;80;68;0;12;G10000270;5;80;68;0;12;G10000271;5;80;68;0;12;G10000272;5;80;68;0;12;G10 000273;5;80;68;0;12;G10000274;5;80;68;0;12;G10000275;5;80;68;0;12;G10000276;5;80;68;0;12;G10000277;5;80;68;0;12;G10000278;5;80;68;0;1 2;G10000279;5;80;68;0;12;G10000280;5;80;68;0;12;G10000281;5;80;68;0;12;G10000282;5;80;68;0;12;G10000283;5;80;68;0;12;G10000284;5;80;6 8;0;12;G10000285;5;80;68;0;12;G10000286;5;80;68;0;12;G10000287;5;80;68;0;12;G10000288;5;80;68;0;12;G10000289;5;80;68;0;12;G10000290;5 ;40;34;0;6;G10000291;5;24;20.4;0;3.6;
So, you can see, the lists are mixed up. The local return is the right one. The 4 first sequences are first and last added to the list, and even more, the dots and comma's are also mixed up.
Can it be this has something to do with the NLS settings, but I can't change it from my Toad-application. I can view it with the query "select NLS_NUMERIC_CHARACTERS from v$nls_parameters". I also have made sure the regional windows settings are the same on both computers. But... it's a bit strange, the NLS settings count for both tomcat applications, don't they? (because I connect to the same database)
Thanks in advance,
Lieven
|
|
|
Re: NLS settings? [message #239602 is a reply to message #239420] |
Tue, 22 May 2007 13:46 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Find out which oracle home each of the app servers uses (assuming it does use one). If you only have a single one it makes things easier. Check the registry entries (using regedit) to look for different NLS settings.
The easiest way to confirm the difference is to dump your session settings (not database) to dbms_output or whatever in the package.
for i in (select PARAMETER, VALUE from NLS_SESSION_PARAMETERS order by 1) loop
dbms_output.put_line(i.parameter||' '||i.value);
end loop;
|
|
|
Re: NLS settings? [message #240620 is a reply to message #239602] |
Fri, 25 May 2007 06:07 |
leevun
Messages: 3 Registered: February 2007 Location: Belgium - Ghent
|
Junior Member |
|
|
Hi, thank you for the answer,
"Find out which oracle home each of the app servers uses (assuming it does use one). "
-> I have a database server on which the local computer and my testserver are logging on. On the local computer oracle is installed, sorry to ask, but the oracle_home directory is the ora92-directory? It's anyhow on c:\oracle\ora92 the database server also has a C:\oracle\ora92. But on both of them there isn't an environment variable defined. The test app server, doesn't have an oracle installed.
"If you only have a single one it makes things easier. Check the registry entries (using regedit) to look for different NLS settings."
-> they both connect to the same database on the same database server
"The easiest way to confirm the difference is to dump your session settings (not database) to dbms_output or whatever in the package."
-> this gave me more!
LOGS local
[Par=]NLS_CALENDAR [value=]GREGORIAN
[Par=]NLS_COMP [value=]BINARY
[Par=]NLS_CURRENCY [value=]€ (this was the euro symbol)
[Par=]NLS_DATE_FORMAT [value=]DD/MM/RR
[Par=]NLS_DATE_LANGUAGE [value=]DUTCH
[Par=]NLS_DUAL_CURRENCY [value=]€
[Par=]NLS_ISO_CURRENCY [value=]BELGIUM
[Par=]NLS_LANGUAGE [value=]DUTCH
[Par=]NLS_LENGTH_SEMANTICS [value=]BYTE
[Par=]NLS_NCHAR_CONV_EXCP [value=]FALSE
[Par=]NLS_NUMERIC_CHARACTERS [value=],. (and this is what I need!)
[Par=]NLS_SORT [value=]DUTCH
[Par=]NLS_TERRITORY [value=]BELGIUM
[Par=]NLS_TIME_FORMAT [value=]HH24:MI:SSXFF
[Par=]NLS_TIMESTAMP_FORMAT [value=]DD/MM/RR HH24:MI:SSXFF
[Par=]NLS_TIMESTAMP_TZ_FORMAT [value=]DD/MM/RR HH24:MI:SSXFF TZR
[Par=]NLS_TIME_TZ_FORMAT [value=]HH24:MI:SSXFF TZR
LOGS testserver
[Par=]NLS_CALENDAR [value=]GREGORIAN
[Par=]NLS_COMP [value=]BINARY
[Par=]NLS_CURRENCY [value=]$
[Par=]NLS_DATE_FORMAT [value=]DD-MON-RR
[Par=]NLS_DATE_LANGUAGE [value=]AMERICAN
[Par=]NLS_DUAL_CURRENCY [value=]$
[Par=]NLS_ISO_CURRENCY [value=]AMERICA
[Par=]NLS_LANGUAGE [value=]AMERICAN
[Par=]NLS_LENGTH_SEMANTICS [value=]BYTE
[Par=]NLS_NCHAR_CONV_EXCP [value=]FALSE
[Par=]NLS_NUMERIC_CHARACTERS [value=]., (and this is what I need! ,see above)
[Par=]NLS_SORT [value=]BINARY
[Par=]NLS_TERRITORY [value=]AMERICA
[Par=]NLS_TIMESTAMP_FORMAT [value=]DD-MON-RR HH.MI.SSXFF AM
[Par=]NLS_TIMESTAMP_TZ_FORMAT [value=]DD-MON-RR HH.MI.SSXFF AM TZR
[Par=]NLS_TIME_FORMAT [value=]HH.MI.SSXFF AM
[Par=]NLS_TIME_TZ_FORMAT [value=]HH.MI.SSXFF AM TZR
Now,
How do I change these settings, and especially, for every future session, NLS_NUMERIC_CHARACTERS has to be this ,.
Thanks in advance
Regards,
Lieven
|
|
|