How to get the same value of NUMBER type in Oracle db when cursor.fetchall() is called

User_4YI8U

Hi,

In my Oracle 19c database, I have a table with many columns of type NUMBER and they store the values like for example 100, 0, 250 etc. However, when SQL Query is executed using cx_Oracle python module (v8.2.1), the cursor.fetchall() method is returning the values of those NUMBER type columns as 100.0, 0.0, 250.0 (with single decimal point). As a result our automation test results comparison is failing.

Could you please suggest/guide me on how to get the exact value of those NUMBER type columns in the same way how Oracle db stored without that additional decimal value (dot zero). Please let me know if you need any additional information on the issue.

Regards,

Chandrasekhar

Christopher Jones-Oracle

• as numbers, the value you quoted are the same.
• Python deals with binary representation of numbers, whereas Oracle has a decimal representation, so there are bound to be some cases where conversion follows rules that you won't like. You can get around this using Python Decimal objects via an output type handler, see https://cx-oracle.readthedocs.io/en/latest/user_guide/sql_execution.html#fetched-number-precision.
• you can also use an output type handler to fetch as strings instead of Decimal - this is probably what you think you want.
• A general recommendation is to do as much numeric calculation in Oracle DB as possible (using SQL or PL/SQL) to avoid conversion issues, particularly when doing financial calculations.

User_4YI8U

Ok. Thank you