Re: Decimals lost when selecting data from database link

On 27 Jun 2003 06:28:57 -0700, marc_at_vanwaardenburg.nl (Marc van Waardenburg) wrote:

>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

Very unlikely. Probably though when you are using Dutch NLS_TERRITORY settings and the AS/400 simply doesn't support the concept in a fashion.
Try setting NLS_TERRITORY to 'America' and check whether you can reproduce the behavior. If it works, you know your NLS_TERRITORY settings are the culprit. You may want to check both client NLS_TERRITORY and database NLS_TERRITORY in init<sid>.ora

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jun 27 2003 - 12:26:30 CDT