How to execute a Stored Procedure in Qlik that returns NO value

Ask a Question

To execute a Stored Procedure in Qlik that does NOT return any value from an Oracle Database using Qlik ODBC Connector Package the CALL control statement must be defined as below ( Fig.1 ), to avoid the following error:

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00900: invalid SQL statement

LIB CONNECT TO 'DEVxxx';

SQL ALTER SESSION SET CURRENT_SCHEMA=K
         !EXECUTE_NON_SELECT_QUERY;

SQL  CALL  k.session#.open_session();

data:
      LOAD * ;
                 SQL select *
                           from k.doc
                           where rownum <10

;

Fig.1