Forum Stats

  • 3,770,151 Users
  • 2,253,079 Discussions
  • 7,875,349 Comments

Discussions

After patching database: TO_CHAR gives other result for a number

Our production environment is on Database Version 19.10 (Oracle Cloud)

We patched our development and staging environment to Database Version 19.12 (Oracle Cloud)

Suddenly all numbers on development and staging returns different result when using to_char in ORDS-calls

Example:

DEV/STG: TO_CHAR(21.34) --> 21,34 (before the patching it was 21.34)

PROD: TO_CHAR(21.34) --> 21.34

It only happens in ORDS-calls. When trying this in SQL/Plus we get the same result on the 3 environments.

ORDS-versions:

DEV: 21.3.0.r2661100

STG: 20.3.0.r3011819

PROD: 20.3.0.r3011819

So STG & PROD are the same version, but also different result in ORDS.

The NLS-settings are the same on the 3 environments. Any idea?

Tagged: