If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Could anybody give me a hand?
I'm struggling for a few days to execute a stored procedure in Oracle database within Qlik Sense:
LIB CONNECT TO 'database';SQL exec sa_bimec.auxiliares.ESCREVE_TABELA;
Just to confirm - this stored procedure executes in Oracle without issue?
If so, try wrapping it in parens and single quotes thusly:
LIB CONNECT TO 'database';SQL EXEC ('sa_bimec.auxiliares.ESCREVE_TABELA');
LIB CONNECT TO 'database';
SQL EXEC ('[sa_bimec].[auxiliares].[ESCREVE_TABELA]');
If that doesn't work, others have found success using web services to accomplish this.
Thanks for your help, buddy.
Yes. When I run the procedure through Oracle database it works properly.
I tried but both didn't work.
Is there anything else that you could recomend ?
Sorry, if those aren't working I think your best option is to use a web service like the people in the link above are doing.
According to: https://community.qlik.com/t5/Knowledge/Calling-a-stored-procedure-or-function-in-Oracle-from-QlikVi...
Use the function CALL to specify the name of the stored procedure.