03-05-2014 03:21 AM
Hello,
I am facing a strange situation: we are upgrading Client OS from XP to Win7/32. DB is Oracle 10g using OLEDB provider which basically works.
But one script failes as follows:
select sum(x) as x from ...
in WinXP it returns in debugger:
rs.Fields(x).Value = -12,34
isNumeric(rs.Fields(x).Value) = true
Test of isNumeric function:
isNumeric(1,2) = Wrong number of arguments...
isNumeric(1.2) = True
Win 7:
rs.Fields(x).Value = -12,34
isNumeric(rs.Fields(x).Value) = false
Test of isNumeric function:
isNumeric(1,2) = Wrong number of arguments...
isNumeric(1.2) = True
select * from nls_session_parameters returns exact same values for both systems in sqlplus. (NLS_NUMERIC_CHARACTERS = .,)