Get Data of an Oracle Table from Sql Server Stored Procedure

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

Dear Friends,

I will develop a Store Precedure in SQL Server, but I need to process data
from a table but this table is in an another Database in Oracle.

How a cand access the data??? please share me any code or link or example where I can do this.

Thanks in advance.

Leonardo Ayala R.

Posted 17-Jan-14 3:33am

leocode7

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Answer 1 · 2014-01-17T07:00:00

Solution 1

http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html[^]

Posted 17-Jan-14 7:00am

Krunal Rohit

Comments

leocode7 20-Jan-14 10:04am

Please friend tell me if you think that a DTS in sqlserver can give me the solution of my problem.... thanks

Christian Graus · Answer 2 · 2014-01-17T07:56:00

Solution 2

I would write a local or web service that talks to both machines and passes data between them.

Posted 17-Jan-14 7:56am

Christian Graus

Comments

leocode7 20-Jan-14 10:04am

Please friend tell me if you think that a DTS en sqlserver can give me the solution of my problem.... thanks

Christian Graus 20-Jan-14 13:45pm

Jörgen has told you exactly what to do, with a link that explains it. Do what he said, and ask if you get stuck.

Jörgen Andersson · Answer 3 · 2014-01-17T09:19:00

Solution 3

You set up a database link[^] to the oracle server.

Posted 17-Jan-14 9:19am

Jörgen Andersson

Comments

leocode7 20-Jan-14 10:04am

Please friend tell me if you think that a DTS en sqlserver can give me the solution of my problem.... thanks

Jörgen Andersson 20-Jan-14 16:16pm

DTS has been superseeded by SSIS.
But yes you can use it, but using it for reading only one table is a bit like using a howitzer for killing a mouse.

Get Data of an Oracle Table from Sql Server Stored Procedure

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Get Data of an Oracle Table from Sql Server Stored Procedure

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us