Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have PL/SQL package call and it return one output. What is syntax to use PL/SQL package call in qlikview script?
Thanks!
How about this:
SQL EXECUTE export_pkg.set_from_date(to_date('$(vMaxDate)','dd.mm.yyyy'));
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
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)');