Re: Cannot set NLS_DATE_FORMAT

If you want the init.ora parameters to take presedence over the registry then remove all nls_ parameters from the registry.

Regards
David Russell

Louis wrote in message <358BBF73.65269D2A_at_cgi.ca>...
>Hello Leon,
>
>You have to edit the Win95 registry and set this value in the appropriate
 entry,
>the one labelled 'nls_date_format'.
>
>1) Start menu -> execute
>2) Type in 'regedit'
>3) Open the branch Local Machine -> Software -> Oracle
>4) On the rigth panel find the entry and edit.
>
>Regards, Louis.
>
>Leon Caruana wrote:
>
>> I am using Personal Oracle 7 and would like to change the default date
>> format to dd-mm-yyyy. I have amended the INTIORCL.ORA initialization file
 in
>> \orawin95\bin to include the following line;
>>
>> nls_date_format = "dd-mm-yyyy"
>>
>> This is accepted as i checked it with the show parameters option.
 However,
>> in any applicationaccessing the database such as SQLPlus, the date is
 still
>> shown as dd-mon-yy unless I issue the alter session command and change
 the
>> nls_date_format again.
>>
>> Does anyone have an idea as to what is happening and how it can be
>> rectified? Thank you very much.
>>
>> Leon Caruana
>
>
>
Received on Sat Jun 20 1998 - 00:00:00 CDT