Linked server 
Author Message
 Linked server
Is it possible to call an Oracle stored procedure from within a linked
server?   And if so, can I grab the results and work with it on the SQL
Server???


Tue, 09 Dec 2003 05:07:47 GMT
 Linked server

yes.  search BOL for "OLE DB provider for Oracle" or some such.  it will
tell you how to set up a linked server for Oracle for which you can call
remote and distributed queries.

hth


Quote:
> Is it possible to call an Oracle stored procedure from within a linked
> server?   And if so, can I grab the results and work with it on the SQL
> Server???



Tue, 09 Dec 2003 08:34:33 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Is It Possible: Linked Server to Linked Server?

2. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

3. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

4. LINKED SERVERS : How to link MySQL server on SQL Sever 2000

5. Reliable link to Oracle server (linked, server, oracle)

6. How linked are linked servers ?

7. Problem linking to Sybase as linked server

8. urgent: link mysql db as a linked server

9. linked server, DTC, SQLOLEDB, Access, linked tables = HEADACHE!

10. Remote Server -- Changing from Remote Server to Linked Server

11. link server from Oracle to SQL server occurs blocking on SQL server

12. Linked Server - Server: Msg 7399 - It is already opened exclusively by another user


 
Powered by phpBB® Forum Software