Re: [cx-oracle-users] Cx_Oracle - Rounding Problem

[Paul M. <p.f...@gm...>]

On 18 January 2011 19:54, Roberto Badillo Ibarra <bet...@ho...> wrote:
> Sorry, i forget to tell you that on Python I'm just Printing the Object, So
> I know that the problem is not on Python.

There may be no problem at all (other than normal float rounding,
which I suspect you're not aware of). See
http://docs.python.org/tutorial/floatingpoint.html

>python
Python 2.7 (r27:82525, Jul  4 2010, 09:01:59) [MSC v.1500 32 bit
(Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> print 99345999999.9999
99346000000.0
>>>

You might want to read up on Python's Decimal type
(http://docs.python.org/library/decimal.html) and its use in cx_Oracle
(see, for example,
http://www.oracle.com/technetwork/articles/tuininga-cx-oracle-084866.html).

Paul.