Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.4 and laterOracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.

Symptoms

Using Database Gateway for ODBC (DG4ODBC) 11.2.0.4 with Data Direct ODBC driver 7.1.3 or Database Gateway for SQL*Server (Dg4MSQL) from Oracle 11g then calling a SQL*Server stored procedure using DBMS_HS_PASSTHROUGH it fails with the following error -