Execute PL\SQL Procedure in QlikSense

[RutiTaumanRubin]

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!

[devarasu07]

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

[RutiTaumanRubin]

Hi,

Thanks for your quick response,

I try to run oracle procedure (not sql server) ,

The procedure only update table in the database...

[MMann]

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.