Often when just installed a new tool, you will find that proven sql’s is not working. Reson for this can be your registry nls_lang is defaulted to the windows language.
Solution:
- open regedit
- find all occurences of “NLS_LAN”
- update to “AMERICAN_AMERICA.UTF8″
This is with NLS_LANG = DANISH_DENMARK.UTF8:
DEV> select userenv('LANG') from dual;
DK
Forløbet: 00:00:00.00
DEV>
This is with NLS_LANG = AMERICAN_AMERICA.UTF8:
DEV> select userenv('LANG') from dual;
US
DEV>