0 Replies Latest reply: Oct 16, 2017 8:06 AM by Tunde Aina RSS

    Execute an Oracle stored procedure that returns a refcursor in Qlik Sense

    Tunde Aina

      Hello Gurus,

       

      I have a stored procedure that runs well and compiles with no errors in Toad for Oracle but it doesn't execute in the load editor.

       

      I am using an ODBC connection to the Oracle database and get the following when I execute in QlikSense.

       

      Error: File Extdata.cpp, Line 2259

       

      This is my stored procedure in Oracle:

       

      CREATE OR REPLACE PROCEDURE Wkly_Ins_Cur(c_result OUT SYS_REFCURSOR)

      AS

       

        BEGIN

              

            -- Drop DT_Weekly table

            EXECUTE IMMEDIATE 'DROP TABLE DT_WEEKLY';

           

            -- Create DT_Weekly table

            EXECUTE IMMEDIATE 'CREATE TABLE DT_WEEKLY

            AS

          

            -- Select Statements with about 9 unions is used here

              -- Open cursor

              open c_result for

              select * from dual;

             -- return c_result;

        

         END;

       

      Please help. Thanks

       

      Kind Regards,

      Tunde