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

[rupalimane1390]

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

[joaopaulo_delco]

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"};

[rupalimane1390]

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.

[rupalimane1390]

Hi @joaopaulo_delco 

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

[shampy19]

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"}

[NadiaB]

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.