Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Not applicable

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

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