Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Connectivity & Data Prep

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this topic

rupalimane1390
Contributor III
Contributor III

Calling and executing Oracle stored procedure in qliksense (Sep 2020 version)

Hello ,

Can anybody guide me to run Oracle stored procedure successfully in qliksense.

I checked almost all threads related to calling Oracle SP in qliksense but could not find successful or completed thread.

I am using following syntax to run Oracle SP in qliksense:

LIB CONNECT TO 'dmtx002i (matrix-data_manerup)';
 

1. SQL exec sp_uk_fc_nc_test_5;

or 

2. I even tried with DB name : SQL exec dmtx002i .sp_uk_fc_nc_test_5;

(dmtx002i is my DB name and sp_uk_fc_nc_test_5 is oracle stored procedure name).

 

 

 

Who Me Too'd this topic