Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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)');