Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SOLUTION : if you experienced the "million bug" executing a binded query

SOLUTION : if you experienced the "million bug" executing a binded query

From: Christophe LAUER <clauer_at_sqli.fr>
Date: Fri, 18 Sep 1998 12:23:55 +0200
Message-ID: <360234BB.9C671BD1@sqli.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US