Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: