Home » RDBMS Server » Networking and Gateways » Need to call SQL server Proc from Oracle.
Need to call SQL server Proc from Oracle. [message #154113] Thu, 05 January 2006 14:47 Go to next message
smthakur
Messages: 1
Registered: January 2006
Junior Member
Hi,

I have to call one sql server proc from Oracle. How can I achieve this? I have database link between sql server as well as oracle. Please, let me know.

Thanks.

Report message to a moderator

Re: Need to call SQL server Proc from Oracle. [message #154156 is a reply to message #154113] Thu, 05 January 2006 23:56 Go to previous message
ramsat
Messages: 49
Registered: November 2005
Member
i believe u r using Oracle heterogenous services Right!

Oracle says that we cannot call a procedure or a function of sql server from Oracle, but i think u can do all the DML operations on a table which is in SQL server. better cast the procedure to Oracle and change the handle so that the datas are managed from oracle to sql server.


I think this could be possible


Bye!

Report message to a moderator

Previous Topic: ora-12541: TNS:no listener
Next Topic: Using DB Links
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 09:14:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.