Re: NLS parameters

For 10.2 exepress on my laptop adding a new string NLS_DATE_FORMAT under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_XE with value YYYY-MM-DD changed my default DD-MON-YY (which BTW is rather ambiguous at least for me ;)

For my work PC adding the same under
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 did the same thing. And my ALL_HOMES/LAST_HOME has value 1, so probably you added under wrong home.

And one more thing - you can get new value only after reconnect.

Gints

2006/4/27, Jonathan Knight <knightjck_work_at_yahoo.com>:
> I tried completely removing the NLS parameters and
> could not connect. I can again connect after
> restoring the NLS_LANG entry.
>
> I just tried addig NLS_DATE_FORMAT to the registry,
> but it doesn't influence the session.
>
> Thanks for the suggestion,
> Jon
>

--
http://www.freelists.org/webpage/oracle-l