How to execute a stored procedure in oracle database within Qlik Sense?

[samuelnormatica]

Hi folks,

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;

I got the following ERROR:

The following error occurred:

ERROR [HY000] ORA-00900: invalid SQL statement

Thanks,

Sam

[andoryuu]

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');

or

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.

[samuelnormatica]

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 ?

[andoryuu]

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.

[MMann]

Hi,  

According to: https://community.qlik.com/t5/Knowledge/Calling-a-stored-procedure-or-function-in-Oracle-from-QlikVi...

Try it:

Use the function CALL to specify the name of the stored procedure.