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 Wed Jul 10 2002 - 11:31:04 CDT
