Oracle link decimal problem

[Stefan]

Hi,

I've got a linked table from Oracle9i Enterprise Edition
Release 9.2.0.4.0 with a field that's declared like this:
XXX_CONVERSION_FACTOR NUMBER(12,4)

In Access the field is automatically declared as Decimal
with precision 12 and scale 4. Problem is that when in
Oracle I have, for a specific article, a conversion factor
that reads 18.21. However, when I select the same article
in Access the conversion factor reads 1821. Has anyone run
into the same problem and if so, is there an easy way to
solve it other than to declare it as a double in the
Oracle database?

Thanks, Stefan

 

[gabo]

Hello,

have you find a solution, because I've got the same problem.

Thank you.

Gaëtan

 

[Stefan Johansson]

Hi,

Nope, no solution so far. I've worked around it by copy
the table into a new Oracle table and change the format to
just NUMBER(). Not the best solution since it means I'll
have to do this each and every month but hey, at least it
works.

Stefan