Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuelnormatica
Contributor
Contributor

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

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
4 Replies
andoryuu
Creator III
Creator III

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
Contributor
Contributor
Author

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
Creator III
Creator III

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
Contributor
Contributor

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.