Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Calling an Oracle stored proc from SQL Server

Author  Topic  sweko Starting Member 5 Posts Posted - 2004-10-08 : 03:41:10 I'm having the following problem. In our company we are using SQL Server as a main database server, but now a package solution (works on Oracle) is implemeted and we need to execute one of already implemented procedure on Oracle (for some interface issued). Problem is that this procedure have input and output parameters, and we can't find some way to execute this procedure and to get result back to the SQL Server. We succesfully made the link to oracle (sp_addlinkedserver) and working with the tables and views from oracle is not a problem. Please tell me how to execute this kind of procedure.