Decimals lost when selecting data from database link

From: Marc van Waardenburg <marc_at_vanwaardenburg.nl>
Date: 27 Jun 2003 06:28:57 -0700
Message-ID: <55c2beda.0306270528.1cbfb9e@posting.google.com>

All,

When selecting data via a database link from Oracle 8.1.7 to AS/400 via heterogeneous services, the numbers are truncated so decimals are lost.

Remarkable is that when I select the column * 100, i do see the decimals in the last two digits. But when I select the column * 100 into an Oracle table then 00 is stored so the decimals are lost again.

Any suggestions? Could it be a regional settings/decimal notation issue? I've tried some changes there (as in the Netherlands the default decimal separator is comma, but with no success. Any other suggestions?

TIA
Marc Received on Fri Jun 27 2003 - 08:28:57 CDT