topic Re: Calling and executing Oracle stored procedure in qliksense (Sep 2020 version) in Connectivity & Data Prep

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

rupalimane1390 — Fri, 27 Aug 2021 13:53:28 GMT

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;

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).

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

joaopaulo_delco — Fri, 27 Aug 2021 14:22:25 GMT

Hi @rupalimane1390 !

I only managed to solve it with an oledb connection. Look at my code below:

LIB CONNECT TO 'Oracle MDLog OleDB (qliksense_administrador)'; // Execute stored procedure SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"};

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

rupalimane1390 — Tue, 31 Aug 2021 08:01:35 GMT

HI @joaopaulo_delco , Thank you for your response. I tried using CALL command but it gives an error saying ' An Indentifier' must be declared where as my stored procedure does not have any parameter or identifier to be passed.

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

rupalimane1390 — Thu, 21 Oct 2021 10:07:15 GMT

Hi @joaopaulo_delco

Thank you for your help. I tried these syntaxes but still did not work. It still gives error.

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

shampy19 — Fri, 17 Mar 2023 09:14:20 GMT

I am also facing the same issue when I am trying to run the below code it throws an error:

SQL {CALL PK_JAZZ_FOBOREC."Get_SPC"}

Error Msg:

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 20001, ErrorMsg: [Oracle][ODBC][Ora]ORA-20001: ORU-10032: procedure Get_SPC within package PK_JAZZ_FOBOREC does not exist ORA-06512: at "SYS.DBMS_DESCRIBE", line 264 ORA-06512: at line 1

The error occurred here:

SQL {CALL PK_JAZZ_FOBOREC."Get_SPC"}

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

NadiaB — Tue, 11 Apr 2023 15:45:43 GMT

Hi @shampy19

It is suggested to create a new post since this is from 2021,

Could you confirm if you are using our connector (Qlik connectors) or a third party connector?

If using our connector, do you get an error, what is the error ?

Kind Regards.