Re: Help Completely Baffled

jk wrote:

> I've tried to set the nls_date_format to 'DD-MON-YYYY' in the
> initorcl.ORA file
> (Oracle 7.2.2) and it seems to be ignored what am I doing wrong.
>
> If I look at the parameter file then it tells me that nls_date_format
> = 'DD-MON
> YYYY' however selecting sysdate from dual always returns the 9
> character date
> format.
>
> Alter session to set nls_date_format always works fine.
>
> How do I get the instance to recognise this new format or can't I.
>
> Please anyone help if you can i'm completely baffled here.
>
> John

   John,
Did you restart oracle after you changed your initSID.oar file? then,
I think you have to check shell script file. if you use csh , then check .cshrc
and if you use sh,ksh, then check .profile. generally, this file has oracle environment variables. example, NLS_LANGUAGE, NLS_DATE_FORMAT etc. you have to change this environment variable.

good luck! Received on Thu Apr 30 1998 - 03:30:26 CDT