Home » SQL & PL/SQL » SQL & PL/SQL » Date shows 00/00/0000
Date shows 00/00/0000 [message #236124] Wed, 09 May 2007 02:26 Go to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Good morning,

I'm facing a strange problem on a database running Oracle 10.2.0.3 on windows in China.

From time to time, a data is inserted and looks like this in our application:

00/05/2007
03/00/2007
00/00/0000

Oracle forms seems to do with it and shows it anyway. Toad has more difficulties and returns the error "0.0 is not a valid time stamp" as soon as the field is displayed and odbc completely fails as soon as it displays the field too (in access, "odbc link fail" and connection lost).

The quick fix is very simple: Edit the date for this entry to a normal date format...

It seems that this problem is not related to the DB version because we had it on 8.1.7 before I migrate to Oracle 10.2.0.3.
I was hoping it could be a bug solved by Oracle 10g.

My problem is that I have no idea of what could be the source of it.

The occurence if not critical is however frequent enough to start worry. I have something like that once or twice a week...

The date is selected in a calendar by the user and they can't edit it...

If somebody has an idea of what could be the source of this problem or could hint me to the right direction, it would be really helpful.

Thanks a lot.

Nicolas
Re: Date shows 00/00/0000 [message #236125 is a reply to message #236124] Wed, 09 May 2007 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The source is a program that inserts (or updates) date field with binary data. For instance, a Pro*C/OCI program.

Regards
Michel
Re: Date shows 00/00/0000 [message #236127 is a reply to message #236124] Wed, 09 May 2007 02:31 Go to previous message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Hi Michel,

thanks a lot for this really quick answer.
It's a huge step forward.

Amicalement,

Nicolas
Previous Topic: String problem
Next Topic: Calling a sql script from a shell script
Goto Forum:
  


Current Time: Sat Dec 03 12:08:43 CST 2016

Total time taken to generate the page: 0.10159 seconds