Oracle bug when your locale isn't English(United States)
843859Aug 20 2007 — edited Apr 28 2010This problem has been discussed before in thread http://forum.java.sun.com/thread.jspa?forumID=48&threadID=559165, but appears to still be unresolved (JRE 1.5.0_11 and Oracle 10g).
Recently I had a PL/SQL function that returned different results when run from SQL*Plus and JDBC. The problem was that I had my WinXP locale set to English(Canada) on the client, and Java had set the NLS_NUMERIC_CHARACTERS to incorrect values that made period the group seperator and comma the decimal point, but the language was not set to French. This might sometimes be correct in Quebec, but never in TROC.
Who should this be reported to, Sun or Oracle, or both.