Hi All,
I am trying to call a function in Oracle database into qlik sense .When i try use the below code it was throws me error:
Below is the sample i used
Function in Oracle :
create or replace FUNCTION MYFUNC
RETURN SYS_REFCURSOR
IS
lv_ret_refcursor SYS_REFCURSOR;
BEGIN
OPEN lv_ret_refcursor FOR
SELECT 'SUCCESS' as result
FROM DUAL;
RETURN lv_ret_refcursor;
END ;
Qlik:
LIB CONNECT TO 'Lib';
LOAD *;
SQL
select
{? = CALL MYFUNC } ;
Error:
The following error occurred:
The following error occurred:
Error: File extdata.cpp, Line 2326
The error occurred here:
SQL select {? = CALL MYFUNC };
Can any one please help me on this.It could be appricated
Thanks
Kumar KVP