caling Oracle stored procedure from DTS..pls answer

• Jeff Gray

  SSChampion

  Points: 10667

  More actions

  January 15, 2007 at 6:58 am

  #683207

  Hi, Look at OPENQUERY() in the SQL server BOL, second topic (T-SQL reference)

  If you have the linked server set up, you should be able to call the sproc using ORACLE's syntax (whatever that is)

  Select * from OPENQUERY(OracleServer,'EXECUTE somestoredprocedure (someparameter) ')

  Never tried it, so I don't know if it will work, but you might give it a shot.

   

  Good luck,

  jg