Q

Calling stored procedures in SQL Server to insert data in Oracle

I have two DB servers: one is SQL Server, the other is Oracle. I need to call some stored procedure in SQL Server in order to insert some data in Oracle. How I could do that?

I have two DB servers: one is SQL Server, the other is Oracle. I need to call some stored procedure in SQL Server in order to insert some data in Oracle. How I could do that?
Oracle includes Heterogenous Services (HS) which lets you query a non-Oracle database through a database link, just as if the remote database were another Oracle database. The remote database can be MS SQL Server if you choose. Have a look at the Oracle documentation on HS.
This was first published in March 2006

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

1 comment

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close