Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

exec stored proc via linked server

Comment:

I have a linked server setup in SQL that points to an Oracle DB. I have a stored proc in Oracle that I want to execute. How do I do this? Thanks

Javascript help

C programming

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am running a stored procedure in SQL Server that queries a linked server which is Oracle. Running the queries in Oracle take no time at all, but then when I run the stored proc they take a long tim...

Summary: I have a linked server setup in SQL Server and the linked server is connected via Oracle OLE DB. I was setup using windows authentication and I was unable to connect. I would get an error saying una...

Summary: I am creating a stored proc that will be used to process a group of records, one at a time. The proc will be handed one record at a time and will perform a series of UPDATE, DELETE, and INSERT statem...