Re: perplexing problem....

From: Glen A Stromquist <gstromquist_at_hotmail.com>
Date: Tue, 18 Sep 2001 21:08:58 GMT
Message-ID: <KJOp7.2118$9j.667039@news1.telusplanet.net>

Thanks

I should have been clearer, the 7.2.3 is running on AIX and the 7.3.3 is running on NT4 sp5, the client apps are all on 2000

I'll check in to the nls_date_format and change it.

>
> First of all: please don't post in HTML. Many newsreaders don't know how
to
> deal with it.
> Secondly: your *real* problem is you are running 7.3.3 and 7.2.3 on
> platforms (win2k) for which it was *never* certified
> Thirdly : evidently the problem is the setting of NLS_DATE_FORMAT which is
> by default DD-MON-YY, and as you are not using the correct format mask in
> your procedure (ie you are relying on client defaults which you should
> *never ever* do), you get this problem.
>
> IMO, your problem is not perplexing at all.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Tue Sep 18 2001 - 16:08:58 CDT