Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use PL/SQL package call in qlikivew script

I have PL/SQL package call and it return one output. What is syntax to use PL/SQL package call in qlikview script?

Thanks!

12 Replies
rbecher
MVP
MVP

How about this:

SQL EXECUTE export_pkg.set_from_date(to_date('$(vMaxDate)','dd.mm.yyyy'));

Astrato.io Head of R&D
Not applicable
Author

Thank you Ralf, but still not works

QV don't like this part "export_pkg.set_from_date", it even has not reached the passed parameters yet

Not applicable
Author

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