Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid Month error on German Oracle Server 8.1.7 using ADO
This error (ORA-01843: not a valid month) can occur if the
NLS_LANGUAGE setting on the client is different as that in the
database AND if the application passes the date as a character string
instead of as an Oracle date variable. For instance if it does an
update like this:
UPDATE emp SET hire_date = :character_variable
In Oracle Forms you would use a date variable here but in visual basic
this is not an option. The only way to get around this error is then
to make the database and the client PC's have identical nls_language
setting.
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<3d2c6149$0$233$cc9e4d1f_at_news.dial.pipex.com>...
> you could also try posting the sql, or trace the session yourself.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
> "newboy" <goldstar_at_nospam.aol.com> wrote in message
> news:3d2c0ab3$0$237$cc9e4d1f_at_news.dial.pipex.com...
> > Hi Roelof,
> >
> > Yes I set the NLS_LANGUAGE. There is an umlaut in Marz so maybe this is
> the
> > problem. There must be a way to deal with this. Maybe I should just stick
> to
> > DD-MM-RRRR?
> >
> > Unfortunately I work from the UK and my customer is in Germany so it is a
> > bit tricky to develop and test.
> >
> > I suppose I should contact Oracle for some assistance.
> >
> > Thanks for the advice.
> > James
> >
> >
> > "rs" <info_at_bytelife.com> wrote in message
> > news:3d2bfb75$0$32524$7a0f4ed3_at_energis-news-env...
> > > Hello James,
> > >
> > > Did u check the NLS_LANGUAGE setting ?
> > > E.g. in dutch OKT is not OCTober
> > > In german i imagine u have an UMLAUT in the March (Marz).
> > > That's going to be difficult for the database !
> > >
> > > Good luck,
> > > Roelof Schierbeek
> > >
> > > R.Schierbeek, DBA
> > > sql : www.bytelife.com/sql4dba.htm
> > >
> > > newboy <goldstar_at_nospam.aol.com> schreef in
> > > > Hi
> > > > I get an invalid month error when I do an insert from a VB6 app using
> ADO.
> > > >
> > > > It only happens on a German system for the month of MARCH only !!!
> > > >
> > > > I can fix it by using a different date mask to_date(date,
> 'DD-MM-RRRR')
> > > >
> > > > 'DD-MON-RRR' doesnt' work even if I set the NLS_DATE parameter to
> match.
> > > >
> > > > Is it an Microshaft ADO bug?
> > > > Anyone got any suggestion please.
> > > > Thanks
> > > > James
> > >
> > >
> > >
> >
> >
Received on Thu Jul 11 2002 - 02:56:44 CDT