Running an Oracle Proc from SQL server

• Joe Fischer

  SSC Enthusiast

  Points: 127

  More actions

  July 15, 2005 at 12:47 pm

  #167887

  Hi all,

  I have linked an Oracle database to mone of my SQL servers.  I had my Oracle DBA place a stored Proc in a package.  He created the package from sample I have found on the MS help pages and Google search on running linked Procs.

  I am trying to run the Proc using openquery in t-sql.  When I run the query I get an error saying thre are no columns in the table to return.  I am guessing the reason there is nothing to return is because I am not passing the parameters correctly.

  Does anyone know how to pass Paramters to a linked Oracle Proc?

  TIA,

  Joe

   

• July 18, 2005 at 8:00 am

  This was removed by the editor as SPAM

• RSingh-135921

  Default port

  Points: 1438

  More actions

  July 18, 2005 at 8:34 am

  #575221

  Joe,

  Try this:

  http://objectsharp.com/Blogs/matt/archive/2005/06/13/2221.aspx

  HTH,

  Ravinder