This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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.