Re: HELP:inserting value of 1 million

Dear Mark,

This problem repeatable time to time.
We also had same problems and our solutions is using another version, for example - 7.3.2.3.0 instead of 7.2.2.2.0

Please look for four digit from left; version odd or even.

Vladimir

In article <36D65A75.46E2_at_nl.origin-it.com>,   Mark van den Nieuwenhuizen <nieuwen1_at_cad-usr.ce.philips.nl> wrote:
> Hello all,
>
> Oracle has confirmed that inserting a value of exactly 1.000.0000 from a
> double host variable from a Pro*C program in a 7.3.2 database on AIX
> resulted in showing :0000 in a tool like SqlPlus. The actual value
> stored in the database is huge, exceeding the 1 million value by far.
> Funny enough some database browsers show the correct value but Oracle
> itself does not. Updating such a column -with a value of 1 million-
> gives a numeric overflow...
>
> Apparently upgrading to 7.3.4. should solve the problem but
> unfortunately the problem persists. Since the Pro*C program is actually
> a DLL it is not clear if it is a server or a client related problem. I
> have seen some pointers indicating that certain Oracle client SQLNet
> DLL's could be involved but this was far from clear.
>
> Oracle support cannot help me, perhaps one of you can give me some
> hints. A last resort could be to force an insert of a value which just
> exceeds the dreaded 1 million but that is really a last resort.
>
> Any help would be appreciated.
>
> Mark van den Nieuwenhuizen
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Feb 27 1999 - 09:46:44 CST