Re: NLS problems

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 28 Aug 1998 10:38:03 GMT
Message-ID: <35e6877f.10942603@news.siol.net>

On Fri, 28 Aug 1998 10:54:39 +0200, "MRinformática" <mrinformatica_at_mx3.redestb.es> wrote:

>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?

You must set NLS parameters also on your client. For 32bit Windows clients you do this in the registry. Run regedit and navigate to HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE and set the NLS_DATE_FORMAT there.
>
>José Ángel Gómez.

HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Aug 28 1998 - 05:38:03 CDT