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

Mon, 16 Oct 2017 12:06:04 GMT

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)

BEGIN

-- Drop DT_Weekly table

EXECUTE IMMEDIATE 'DROP TABLE DT_WEEKLY';

-- Create DT_Weekly table

EXECUTE IMMEDIATE 'CREATE TABLE DT_WEEKLY

-- 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

topic Execute an Oracle stored procedure that returns a refcursor in Qlik Sense in Management & Governance