Error retrieving results from a table performing multiplication on column · Issue #34 · oracle/python-cx_Oracle (original) (raw)

In python 3.5.5 running cx_Oracle 6.0b2 and connecting to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

If I run a query such as:

SELECT price*100
FROM my_table

and I try to retrieve the result using fetch, python seems to fail with the error: ValueError: invalid literal for int() with base 10: '0.0157'

Does anyone know what the issue could be? If I remove the multiplication by 100 it seems to work fine without any issues.

Moataz