Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kumarkp412
Contributor II

Error: File extdata.cpp, Line 2326

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

Community Browser