Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
General Database Discussions
This discussion is archived
on Aug 8, 2012 2:32 PM by Mkirtley-Oracle
How To Call SQL Server SP's in Oracle 11G
Aug 8, 2012 12:22 PM
I have sucessfuly established the connectivity between Oracle 11G and SQl Server 2008 and I am able to select the data from views or tables of sql server in oracle.
but now I have 1 issue I am not able to call or execute the SP's or function of sql server in oracle 11G.
Can you please suggest or help me.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: How To Call SQL Server SP's in Oracle 11G
Aug 8, 2012 2:32 PM
in response to
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