怎樣在SQLServer2000中調用Oracle的存儲過程

Question

我這邊有個需求，需要在SQLServer 2000 中調用Oracle中的存儲過程， 請問是否可以實現 ？ 實現方式是？

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

首先你需要将oracle中的存储过程生成创建脚本
然后在sql2k查询分析器里面执行该脚本 如果语法不对 请根据t-sql来进行修正 
最后创建成功之后你可以这样来调用 

  Exec  存储过程的名字  @ 参数1=值1,@参数2=值2 ,.....

 

Answer 2

我這邊有個需求，需要在SQLServer 2000 中調用Oracle中的存儲過程， 請問是否可以實現 ？ 實現方式是？

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

EXEC sp_addlinkedserver 'OracleSvr',
   'Oracle 7.3',
   'MSDAORA',
   'ORCLDB'
GO
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO

---

More: blog.csdn.net/happyflystone

Answer 3

我這邊有個需求，需要在SQLServer 2000 中調用Oracle中的存儲過程， 請問是否可以實現 ？ 實現方式是？

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

EXEC sp_addlinkedserver 'OracleSvr',
   'Oracle 7.3',
   'MSDAORA',
   'ORCLDB'
GO
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO

---

More: blog.csdn.net/happyflystone

你這個是直接執行語句，我知道這格式。
我想問的是 怎麼在SQLServer2000中執行Oracle的存儲過程？

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 4

SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO

---


SELECT *
FROM OPENQUERY(OracleSvr, 'begin   模式名.proc_name(参数);   end;  ')
GO

链接SQL   Server的链接服务器可以直接：
SELECT *
FROM OPENQUERY(OracleSvr, 'exec proc_name ')
GO
希望对你有帮助

---

More: blog.csdn.net/happyflystone