Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to execute strode procedure from load script in qliksense (I have oledb connection to the database)
I try to write the following syntax:
SQL Execute TRY();
but it didn't work...
Could you please help?
Thank you!
Hi,
Try like below,
LIB CONNECT TO 'BI_WHS';
Students:
load *;
SQL exec dbo.Students;
Store * from Students into 'lib://QVD/Students.qvd';
Hope this helps you
Regards,
Deva
Hi,
Thanks for your quick response,
I try to run oracle procedure (not sql server) ,
The procedure only update table in the database...
Hi,
according to: https://community.qlik.com/t5/Knowledge/Calling-a-stored-procedure-or-function-in-Oracle-from-QlikVi...
Use the function CALL to specify the name of the stored procedure.