This discussion is archived
1 Reply Latest reply: Nov 21, 2013 12:37 PM by Jeff Smith SQLDev PM RSS

4.0EA3 ignores NLS settings?

apodictus Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points