DTS:How to capture result of an oracle SP

• ramesh.register

  Newbie

  Points: 1

  More actions

  December 23, 2010 at 1:12 am

  #229879

  Hi,

  I am trying to call an oracle sp from Transform Data Task in DTS Package.

  The SP returns result as an out parameter of ref cursor type.

  How do I create a variable of type equalent to refcursor and pass it as out parameter?

  My connection uses MS OLEDB driver for oracle.

  Thanks,

  TS.

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  December 26, 2010 at 7:38 am

  #1266310

  This is an Integration Services (SSIS) forum.

  You can find the DTS forum here.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP