:00000 is stored in NUMBER(12) field, Oracle 7.3.3 Workgroup Server for Windows NT

Did anyone experience something of the kind? I'll try to describe the problem.

Application written in Delphi 4 + BDE 5.01 is running on Windows NT 4.0 workstation and communicating through SQL*Net with Oracle 7.3.3 workgroup server running under Windows NT 4.0 server. Sometimes very strange values are stored in the fields of type NUMBER(12)
In SQL*Plus they look like :00000 (colon followed by 5 zeros) and the only way to display the rows containing these values is to issue the query:

select * from mytable
where to_char(myfield) = ':00000';

Being sent to a client application these values are represented by a very large float numbers (e+308) and cause "value out of bounds" error.

Hexadecimal representation of this value is FFFF FFFF FFFF EF7F I must admit that the same application running under Win95/98 workstation communicating with the same Oracle server doesn't cause this

problem.
I don't know who is to blame: Oracle server (very unlikely), Oracle SQL*Net, Oracle Call Interface, Borland Oracle SQL Link, BDE, ...? I would greatly appreciate your help and advice

Thanks in advance
Anna Sotnichenko Received on Wed Jun 23 1999 - 19:55:46 CDT