Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!

Labels (1)
12 Replies
rbecher
Partner - Master III
Partner - Master III

How about this:

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

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
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)');