ODBC Call Failed - Numeric Value Out of Range error when linking to an Oracle table
Posted on 2013-01-16
I am linking to a Oracle table via ODBC. The Oracle table has well over 300,000,000 records and am getting the message ODBC Call Failed - Numeric Value Out of Range (#0). Interestingly other tables that have less than 100,000 records I have no issues with the ODBC link to an Oracle table.
The other item to note is I previously linked this table (the table that now has >300M records) years ago in a different database so I went and opened the database and had no problem opening the table or running queries against this table. I am able to see the most recent data. However, if I try to refresh the link I get the same error ODBC Call Failed - Numeric Value Out of Range (#0).
If the error is due to volume issue would a Pass-Thru work as I only need recent data...