Hi Jmodic!Problem setting NLS_DATE_FORMAT IN THE REGISTRY SETTING ON WIN98!URGENT!
Hi Jmodic!
I had tried both ways i.e.,by setting new key in the registry in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ORACLE_HOME
and also by setting in the new string as:
variable name:NLS_DATE_FORMAT
VALUE:DD-MON-YYYY
On the other hand,I had also set it permanently in the INIT.ORA Parameter File.But still I am not getting the date format in 2001!
What else should I do!
Could you please explain me step by step the setting of both registry and INIT.ORA Files for NLS_DATE_FORMAT.
Regards,
Amitstora.
Re: Hi Jmodic!Problem setting NLS_DATE_FORMAT IN THE REGISTRY SETTING ON WIN98!URGENT!
Quote:
Originally posted by amitstora
I had tried both ways i.e.,by setting new key in the registry in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ORACLE_HOME
and also by setting in the new string as:
variable name:NLS_DATE_FORMAT
VALUE:DD-MON-YYYY
I'm not sure I understand exactly what you have done, but I suspect you have set the NLS_DATE_FORMAT variable in the registry keyHKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ORACLE_HOMES, which is not correct place for this setting. Set it in the following key:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0. If you have more than one oracle_home then it might also be HOME1 or HOME2 or HOMEn instead of HOME0 - determine which home is the right one for the tool/aplication you are using and set NLS_DATE_FORMAT there.