Execute sql server procedure from oracle 10g through dblink

$10-30 USD

Closed

Posted

about 7 years ago

$10-30 USD

Paid on delivery

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.

Microsoft SQL Server

Oracle

Project ID: 13108388

About the project

9 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

9 freelancers are bidding on average $27 USD for this job

@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 clarifications.

$25 USD in 1 day

3.6

(1 review)

2.7

@mra58a1b705c636c

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@grovatti

A proposal has not yet been provided

$25 USD in 1 day

0.0

(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, procedures, functions , using new features of db etc. if you think my profile is suitable for your requirement then you can contact me. Thanks and Regards Amarjot

$25 USD in 1 day