Execute Oracle Package in Power Pivot - Table Import Wizard RRS feed

  • Question

  • Hi, I am trying to use Powerpivot to execute a oracle package to bring in the table.

    I went into Table Import Wizard...and tried a couple of different syntax to execute the package then click "!" but none return any error or results... Have anyone tried this and know the syntax?

    Here is what i have tried

      -- Call the procedure
      oms.test.test1(indate => :indate,
                     instring => :instring,
                     inlimit => :inlimit,
                     rc1 => :rc1);

    Friday, April 19, 2013 6:25 PM