1 Reply Latest reply: Nov 21, 2013 2:37 PM by Jeff Smith Sqldev Pm-Oracle RSS

    4.0EA3 ignores NLS settings?

    apodictus

      I just installed 4.0EA3 and it seems to be ignoring the NLS settings in preferences completely.

       

      NLS settings are (amongst others)

      NLS_DATE_FORMAT => DD-MM-YYYY H24:MI:SS

      NLS_NUMERIC_CHARACTERS => .,

       

      However dates in a grid are returned as 11-NOV-13

      and select to_number(1.1) from dual results in ORA01722

       

      Only after executing

      alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';

      ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';

       

      things work are supposed.

       

      is this a bug?

       

      Geert