Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
3 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.