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

Caterina_Fruci — Tue, 10 May 2022 19:14:14 GMT

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

article How to execute a Stored Procedure in Qlik that returns NO value in Official Support Articles

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

Environment

Related Content