MSSQL linked Server
Database
2
Posts
2
Posters
0
Views
1
Watching
-
I am trying to call Oracle store procedures from MSSQL via linked server connection. For every kind of oracle store procedure, I am receiving several error messages coming from oracle OLEDB or ODBC provider telling that there are syntax errors. I am looking for a solution. Thanks.
-
I am trying to call Oracle store procedures from MSSQL via linked server connection. For every kind of oracle store procedure, I am receiving several error messages coming from oracle OLEDB or ODBC provider telling that there are syntax errors. I am looking for a solution. Thanks.
Show the complete code that you're using to call the Oracle stored procedure, please, including OPENQUERY or whatever else, the error text, etc. Thank you. Jeff Varszegi