Oracle Reports (MOSC)

MOSC Banner

Wrong NLS_NUMERIC_CHARACTERS when runing Report from Builder

edited Aug 27, 2014 10:14AM in Oracle Reports (MOSC) 2 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center