Executing an Oracle Package from Qlikview

[#1]

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.

[#2]

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

[#3]

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;

[#4]

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