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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.