OPENQUERY Gives "Invalid Data for Type "Numeric" Error While Querying Table Containing Numeric Columns (Doc ID 790665.1)

Last updated on SEPTEMBER 15, 2010

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.1.0 to 10.2.0.4 - Release: to 10.2
z*OBSOLETE: Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)
Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)
Linked Server
MS SQL Server 2005
MS Windows x64

Symptoms

You are trying to retrieve data from a Oracle Table using OPENQUERY through a Linked Server.
Linked Server is using Oracle OLEDB Provider to connect to the Database.
While retrieving the data, the OPENQUERY gives the following error:

Invalid data for type "numeric"

This error is seen only with the tables containning numeric columns (columns declared with NUMBER type). It can be seen that some of the table data is retrieved but is never displayed.


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