ITPUB

Jun 17, 2016 · Databases

Linked Server Numeric Error on Oracle 10g/11g – Why It Happens and How Updating the Oracle Client Fixes It

A SQL Server 2005 linked server to an Oracle database throws error 9803 for a numeric(19,4) column, with values ≥10 showing inconsistent failures, and the issue is resolved by installing the Oracle 11g client on the SQL Server host.