Calling of Oracle database Stored Procedures with out parameter and Functions in qlik sense and load the output into qvd

Akhtar — Tue, 04 Jun 2024 08:25:02 GMT

i am trying to load oracle database stored procedures output using out parameter and functions returning the values from oracle database to Qlik sense using below mentioned methods and getting the same error which is

"Executing non-SELECT queries is disabled. Please contact your system administrator to enable it."

Method-1

DOO_HEADERS_ALL:
load *;
SQL CALL mg_cust.QLK_GET_DOO_HEADERS_ALL_PRC('V_RESULT') !EXECUTE_NON_SELECT_QUERY;

Method-2

DOO_HEADERS_ALL:
load *;
SQL CALL mg_cust.QLK_GET_DOO_HEADERS_ALL_PRC('V_RESULT');

Method-3:

DOO_HEADERS_ALL:
load *;
SQL EXEC mg_cust.QLK_GET_DOO_HEADERS_ALL_PRC('V_RESULT');

STORE DOO_HEADERS_ALL INTO $(vLoad_E)/DOO_HEADERS_ALL.QVD](qvd);
Drop Table DOO_HEADERS_ALL;

i am getting the same error as attached, Please guide me to resolve this.

topic Calling of Oracle database Stored Procedures with out parameter and Functions in qlik sense and load the output into qvd in Featured Members

Calling of Oracle database Stored Procedures with out parameter and Functions in qlik sense and load the output into qvd