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.