Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SOLUTION : if you experienced the "million bug" executing a binded query
Hi evrybody,
I'm so happy to have finally found the answer that i decide to give it to you all :
Using Delphi (or any other dev. tool), when i did
UPDATE MY_TABLE SET MY_COL = :p_MyValue , il p_MyValue is
1,000,000.00
i got finally and overflow value in the column 1.797xxxE308, and
TO_CHAR(MY_COL) gives ':0000' as a result.
The trouble seems to come from a MS VC++ dll used by some misc component of the Oracle / SQL*Net / ODBC pipe :
(This come from Borland, in the Delphi Tips ... )
TA1998091470 - BDE / Oracle 7 and the value, 1 million
Oracle 7 and the value, 1 million
Product : BDE [all versions] Author : European Professional Services
DESCRIPTION
We have, at various times, received reports of people unable to enter
numbers of the value
of exactly 1 million into Oracle 7 tables. It has come to our attention
that the problem
does not lie with the BDE, nor even with Oracle's SQL*Net, but with the
version of the
Visual C++ Runtime library, MSVCRT.DLL installed on your system. The
workaround, therefore,
is to swap to a different version of MSVCRT.DLL. One MSVCRT version that
has been shown to work is 5.00.7303.
Bye, Christophe. Received on Fri Sep 18 1998 - 05:23:55 CDT