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

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 14-FEB-2011


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms