topic Executing an Oracle Package from Qlikview in QlikView

Executing an Oracle Package from Qlikview

Tue, 13 Oct 2009 16:22:45 GMT

Hi There,

How can I get to execute an oracle package from Qlikview. I've already tried the below

SQL

EXECUTE "package1.start_rpt"; and SQL CALL "package1.start_rpt";

Im not interesting in waiting for a response from the above package when complete as I can do a reload of the Qlkiview document but I need to get info from a table based on the above package when complete.

The connection to the Oracle database is working OK as I am already reading tables from the database.

Thanks,
Kevin.

Executing an Oracle Package from Qlikview

Tue, 13 Oct 2009 20:31:43 GMT

It only permits use ODBC with read-only access . What is it does your package?

Re: Executing an Oracle Package from Qlikview

Thu, 08 Aug 2013 18:56:27 GMT

I have the same problem too

my package fill the table

I need to exec package.procedurename to fill the table.

it's not works

SQL EXEC export_pkg.set_from_date;

Re: Executing an Oracle Package from Qlikview

Fri, 09 Aug 2013 08:46:06 GMT

it's works with CALL instead EXEC/EXECUTE

thanks

http://qlikviewmaven.blogspot.ru/2012/12/execute-oracle-procedure-from-loadscript.html

// Call Oracle data summarization procedure
sql call corp_report.update_rpt_data('$(var_COUNTRY)');