Oracle Database Discussions

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
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.45
650000432;1;74;62.9;0;11.1;

So, you can see, the lists are mixed up. The local return is the right one. These 4 first sequences are first and last added to the list (which is actually bigger, you can see it below in a later post), 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

Message was edited by:
user575864