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

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version: 11.1.0.6 and later   [Release: 11.1 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