This content has been marked as final. Show 1 reply
Which gateway are you using to connect to SQL*Server ? Is it the Database Gateway for SQL*Server (DG4MSQL) or Database Gateway for ODBC (DG4ODBC) ?
If it is DG4MSQL then have a look at this note in My Oracle Support -
Different Methods For Calling MS SQL Server Procedures Using DG4MSQL (Doc ID 197192.1)
If you still have problems using DG4MSQL then post an example of what you are trying to do and the errors you receive.
If you are using DG4ODBC then this does not support calling remote stored procedures.
Edited by: mkirtley on Aug 8, 2012 3:32 PM