0 Replies Latest reply: Dec 19, 2017 1:11 AM by kvp kumar RSS

    Error: File extdata.cpp, Line 2326

    kvp kumar

      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