MSAccess fails with [Oracle][Odbc]Numeric Value Out Of Range. (#0)

(Doc ID 1318028.1)

Last updated on NOVEMBER 14, 2017

Applies to:

Oracle ODBC Driver - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

Attempting to link a table in Microsoft Access  may result in the following:

Oracle's ODBC driver
ODBC -- Call failed.
[Oracle][ODBC]Numeric value out of range. (#0)

Microsoft ODBC driver for Oracle
ODBC -- Call failed.
[Microsoft][ODBC driver for Oracle]Error in column 11: Numeric value out of range (#0)



Examining an ODBC trace of the failure shows the problem occurs during a SQLGetData call for the 11th column of the results returned by a call to SQLStatisticsW

MSACCESS 310-934 EXIT SQLGetData with return code -1 (SQL_ERROR)
HSTMT 08F81A28
UWORD 11
SWORD 99 <SQL_C_DEFAULT>
PTR <unknown type>
SQLLEN 4
SQLLEN * 0x00136898

DIAG [22003] [Oracle][ODBC]Numeric value out of range. (0)

Changes

This behavior may occur with no noticeable changes to the environment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms