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

[Caterina_Fruci]

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

 

Environment

• Qlik Sense Business 
• Qlik Cloud 
• Qlik Sense Enterprise on Windows 
• QlikView 
• Qlik Sense Desktop 

Related Content

• Qlik Help: SQL Script statement
• Oracle Database SQL Reference: CALL