Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Akhtar
Contributor II
Contributor II

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

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.

0 Replies