NLS problems

From: MRinformática <mrinformatica_at_mx3.redestb.es>
Date: Fri, 28 Aug 1998 10:54:39 +0200
Message-ID: <6s5r0q$c58@wendy.mad.servicom.es>

Hi!
I have problems with the NLS_DATE_FORMAT parameter in the server. I work on Oracle 7.3 an Win NT as Server and Win95 as client I configure my configuration file for the instance ORCL with NLS parameters.

When I start SQL*Plus in the client and try to insert some record with the date format that I have specified, Oracle returns a message saying this is not a valid month.

When I execute ALTER SESSION SET NLS_DATE_FORMAT="DD/MM/YYYY" and try to insert the same record, all is OK.

¿What do I do bad?
¿How can i tune my installation to work with this date format without
execute an ALTER SESSION?
¿Is there any configuration parameters in the client?

I can't change the SQL commands because it would cause a very hard work.

Thanks for any help.

Sorry my English

Please send me any coppy of yhe answer to: mrinformatica_at_mx3.redestb.es
or
jangel_at_jet.es

José Ángel Gómez. Received on Fri Aug 28 1998 - 03:54:39 CDT