caling Oracle stored procedure from DTS..pls answer

• basam nath

  SSC Enthusiast

  Points: 110

  More actions

  January 12, 2007 at 3:24 pm

  #67908

  In the DTS package I am using an oracle stored proc is called. But I do not understand the syntax for "call". can some one tell me what this command is and where I can get some documentation? supposedly "call" is a ODBC command.

  { call fasdig.xxx({resultset 1,Out_LoadStatus}) }

   

  where fasdig is a schema name and xxx is the stored proc name.

• 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