Display of large Oracle numeric columns is incorrect

There appears to be a bug with the Oracle ODBC Driver in that large numbers (eg. 17 digits or more) have their last digits replaced with zeros. There are two circumventions to this problem:

• use the Microsoft ODBC Driver for Oracle. Normally we don't recommend using this driver, however in this case it works better than the Oracle driver.
• use the to_char() function. When this is used, the number is displayed correctly.