RE: NLS parameters

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@xxxxxxxxxxxxxx> wrote:

> You could add NLS_DATE_FORMAT to the registry. 
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Jonathan Knight
> Sent: Thursday, April 27, 2006 2:49 PM
> To: shrekdba@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxx> 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@xxxxxxxxx
> >
>
------------------------------------------------------------------------
> > "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

Other related posts: