Hi All,
When the report is generated, the decimal values are reflected with a COMMA (,) generally up to 10:30 am and after that, the same report when generated shows a DOT (.) separator for the decimal values.
Later again sometime after 12:00 PM, the values start showing (,) again.
Below is snapshot of the report where the inconsistency is highlighted. The CLOB returned from database server is saved in a test_log table in Oracle environment. No format changes are applied in our PLSQL.
Attached are the reports from yesterday and Today.
Here are the settings that we see in Environment at DB Level
NAME VALUE
------------------------------ ------------------------------
nls_language AMERICAN
nls_territory AMERICA
nls_sort
nls_date_language
nls_date_format
nls_currency
nls_numeric_characters
nls_iso_currency
nls_calendar
nls_time_format
nls_timestamp_format
nls_time_tz_format
nls_timestamp_tz_format
nls_dual_currency
nls_comp BINARY
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
More..
PARAMETER VALUE
------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 11.2.0.4.0
Any pointers why we have this inconsistent behavior?
Thanks.
st