OPENQUERY Gives "Invalid Data for Type "Numeric" Error While Querying Table Containing Numeric Columns
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)
MS SQL Server 2005
MS Windows x64
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.
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