I am trying to call a SQL Server stored procedure from ORACLE through an ORACLE Gateway.
The stored procedure has a single 9 character parameter passed in and then populates an ORACLE transfer table with a single record.
Can someone please advise as to the best method of doing this and the correct syntax.
DG4MSQL is fine. There's a note available in My Oracle Support I've written a while ago which calls a SQL Server procedure that inserts a record into the SQL Server table which you can then fetch separately using the gateway.
Please have a look at:
Different Methods For Calling MS SQL Server Procedures Using DG4MSQL (Doc ID 197192.1)