RE: NLS parameters

From: Jonathan Knight <knightjck_work_at_yahoo.com>
Date: Thu, 27 Apr 2006 12:19:44 -0700 (PDT)
Message-ID: <20060427191944.52631.qmail@web60623.mail.yahoo.com>

I tried completely removing the NLS parameters and could not connect. I can again connect after restoring the NLS_LANG entry.

I just tried addig NLS_DATE_FORMAT to the registry, but it doesn't influence the session.

Thanks for the suggestion,
Jon

Igor Neyman <ineyman_at_perceptron.com> wrote:

> You could add NLS_DATE_FORMAT to the registry.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Jonathan Knight
> Sent: Thursday, April 27, 2006 2:49 PM
> To: shrekdba_at_gmail.com
> Cc: oracle-l_at_freelists.org
> Subject: Re: NLS parameters
>
> Thanks Bill.
>
> In the Registry, I have reset
> NLS_LANG = 'AMERICAN_AMERICA.WE8ISO8859P1'
> but, I don't find NLS_DATE_FORMAT.
>
> The home selector just appears to change the PATH
> variable, but not any
> NLS settings.
>
> Jon Knight
>
> --- bill thater <shrekdba_at_gmail.com> wrote:
>
> > > Oddly, this has affected connections from either
> oracle home,
> > > including the original one. I am changing the
> oracle home by
> > > altering the PATH environment variable.
> > >
> > > Any ideas on defaulting NLS_DATE_FORMAT back
> like
> > it
> > > was?
> >
> > you may need to go into the registery and change
> the value in the
> > variable there. or use the home changer that
> should be part of the
> > installer install. at least it was on mine before
> the windows box
> > died.
> >
> > --
> > --
> > Bill "Shrek" Thater ORACLE DBA
> > shrekdba_at_gmail.com
> >

>

> > "All the girls say
> > Save a horse, ride a cowboy."
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 27 2006 - 14:19:44 CDT