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.

Linked ServerNumeric ErrorOLE DB

0 likes · 4 min read

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