DTS: Calling Oracle Stored Procedure. RRS feed

  • Question

  • Hi Can some one help me in calling an Oracle SP from TransformData Task/ExecuteSQL Task in DTS Package?

    I am calling as below

    {call package_name.proc_name(?,?,?,?,?)}

    And when I clicked on the Parameters button to map parameters, getting error as "Provider cannot derive Parameter Information and SetParameterInfo has not been called."

    Same error occurs with both Oracle Oledb and MS Oledb drivers.

    Thanks in Advance,


    • Edited by TravelingSoldier Thursday, December 23, 2010 7:39 AM changed proc name
    Thursday, December 23, 2010 7:38 AM


All replies