Execute sql server procedure from oracle 10g through dblink

Closed

Description

I have a Procedure in SQL Server database and it need to be executed from Oracle 10g database. We have a DBlink available from oracle to sql server already. I would provide the code which gets executed on sql server successfully and I would need the code which would get executed sucussfully in Oracle 10g . DBlink name would be provided. We tried using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE and it didn't help.

Procedure would have around 40 parameters.

Skills: Microsoft SQL Server, Oracle

See more: help setting access application cloud sql server end, perl sql server execute stored procedure, mysql database procedure, mysql duplicate database procedure, find user registration database procedure dnn, execute perl script stored procedure sql server, name rdbms provide facility store procedure, procedure sql server copy database, bcp stored procedure sql server, oracle script sql server script, conert oracle script sql server script, convert oracle script sql server script, create oracle script sql server script, oracle mysql sql server db2, create oracle script sql server, test procedure sql server 2000, oracle scripts sql server 2005, bcp procedure sql server 2000, script stored procedure sql server 2000, zip code radius stored procedure sql server, crystal report coding database procedure

Project ID: #13108388

10 freelancers are bidding on average $30 for this job

truongnguyen86

Hello there, i'm expert on both SQL Server and Oracle, i've done many project with both before, you can check my profile to see. Actually db link from oracle and link server from sql server are fine but i often use lin More

$50 USD in 1 day
(79 Reviews)
5.8
AliSafder

I can work on it. Let me know when to start? I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.N More

$25 USD in 3 days
(13 Reviews)
4.3
point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in More

$35 USD in 1 day
(8 Reviews)
3.7
$35 USD in 2 days
(0 Reviews)
0.0
mra58a1b705c636c

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
dvaliente

I can help you, once we take online contact. I'm expert in ORACLE. I'm Computer Analyst with a great experience in this kind of things.

$25 USD in 1 day
(0 Reviews)
0.0
nprasadsql

Hi, I have experience on SQL Server and Oracle. I have used DBLINK in Oracle and linked servers in SQL Server to access remote databases. I can fix this problem, Please feel free to reach me out for any clarificatio More

$25 USD in 1 day
(0 Reviews)
0.0
amarjotrocky

Hi, My name is Amarjot from India working as database developer (oracle, mysql, sybase) having around 7+ experience in the same. I have hands-on performance tuning of the queries and also worked in making packages, More

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
grovatti

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0