Home » Developer & Programmer » Precompilers, OCI & OCCI » Storing U Long Long with setDouble()
icon4.gif  Storing U Long Long with setDouble() [message #145306] Wed, 02 November 2005 06:43
Messages: 1
Registered: November 2005
Junior Member

I try to store an unsigned long long variable in a NUMBER field using the Statement class. As far as I understand I have to use the setDouble() method since this is the only way to store a 64-bit value?

The problem is that when I try to store the value 1123456789012356 (should fit in the mantissa part of the double) the value 1123456789012360 is stored instead.

I feel the value doesn't fit in the 52-bit mantissa part of the double or something? Anyone experiened similair problems or am I missing something?

* ps. When I manually executes the sql statement in sqlplus it stores the correct value. ds.

Best Regards
Benny Antonsson
Previous Topic: OCI and Advanced Queuing
Next Topic: storage procedure , parameter , C#
Goto Forum:

Current Time: Fri Jul 10 15:28:14 CDT 2020