Wrong NLS_NUMERIC_CHARACTERS when runing Report from Builder
Hi,
We have some numbers stored in DB as strings with dot as decimal separator - and this works fine
(NLS_NUMERIC_CHARACTERS is ". ").
But when I run a Report from my PC (from Reports Builder), I get "not number" on values with dots.
Displaying the "NLS_NUMERIC_CHARACTERS" value from NLS_SESSION_PARAMETERS shows ", " and I can't
understand from where this comma appeared.
Can anyone explain how it can happen and how to fix it?
I can't and don't want to change any report because they all work in production environment.
Thanks in advance,
G.R.