BIGINT in SQL SERVER =====> NUMBER(37) in ORACLE 9.2
Posted on 2006-11-15
I try to expose my problem. I have a SQL SERVER DataBase: for me it's a "remote" DataBase from which I have to read data, in order to load it into an Oracle 9.2 DataBase. Some columns in the SQL SERVER DataBase are typed BIGINT. So, when I read data stored in a BIGINT column, for example 59 and 65 and 77, using ad Oracle Driver for the interconnectivity I read 3,83509655768269E18 and 3,90602825181377E18 and 3,97864879580512E18.
How can I fix this? Please assume that:
1) I cannot modify the SQL SERVER DataBase in any way;
2) The Driver for the interconnectivity cannot be easily changed/upgraded, due to high upgrade costs and to high delivery times for the upgrade.
Is there any way to convert that exponential numbers, in order to extrapolate 59, 65 and 77, the original numbers?
How can I fix this?
Thank you in advance for your kind cooperation.
Rome, November 15th, 2006.