My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.