Decimal Values Are Rounded To 2 Decimal Although Scale Is Greater Than 2 (Doc ID 843802.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Symptoms

When I retrieve number values from SQL SERVER 2005 via HSODBC or DG4ODBC, decimal number with more than 2 decimal digits are truncated to 2 digits ans sometimes values are rounded.

Example:

In SQL SERVER, we have:

col1
---------------------------------------
1.330800
0.930800
1.500000
1.420000
1.517800
0.865200
1.422000
5.311600
1.755200
2.746600

In Oracle, we get:

SQL> desc my_table0@dblink;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
 COL1                                    NOT NULL NUMBER(12,6)

SQL> select * from my_table0@dblink;

COL1
----------
      1,33
       ,93
       1,5
      1,42
      1,52
       ,87
      1,42
      5,31
      1,76
      2,75

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.