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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-07 : 08:03:04
|
| Tom Keith writes "Hi SQL Gurus,I have a Oracle linked server in SQL Server. I am able to query Oracle Tables & Views from SQL Server. However, I do not know how to execute a Oracle stored procedure (simple or one with returns REF cursors) from SQL Server.Any ideas?Thanks,Tom" |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-04-08 : 09:16:43
|
| Try OpenQuery. I don't know if it will work (I've never tried it), but I think it's what you are looking for.From BOL...EXEC sp_addlinkedserver 'OracleSvr', 'Oracle 7.3', 'MSDAORA', 'ORCLDB'GOSELECT *FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles') GOI think you could substitute the SELECT stmt with a SP name.JonNow I know, and knowing is half the battle!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013 |
 |
|
|
|
|
|
Linked Server