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)
-- 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;
Please help. Thanks