7 Replies Latest reply: Sep 30, 2011 11:24 AM by hrdzpqkv RSS

    can QlikView load data from an oracle stored procedure ?

      Is anyone able to get a record set from an oracle stored proc with an output type of refcursor ?

       

      If you are, please share.

       

      I have a very simple procedure.  It takes two in params of string type and one out param of refcursor type.

       

      The issue seems to be around the bind variable for the output cursor. 

       

      I have tried every load statement and argument list combination that I can think of:

       

      LOAD *;

      SQL CALL sp_name('string1','string2', what-goes-here ?)

       

      mostly, I get the "wrong number or type of argument" error.

       

      Thanks for any thoughts.

       

      TD