Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sergeylotvin
New Contributor

Run Stored Procedure by clicking the Button

Hello! Is it possible to run stored procedure by clicking the button placed on the sheet?

I can do it via script, like:

ODBC CONNECT32 TO ORA1 (Mode is write, XUserId is myuserid, XPassword is mypasshere);

SQL

call cntu.LSP_UPD_TEST(138);


And then put reload action on button, but I wonder, if it's possible to run the stored procedure without re-run the main script.


Thanks in advance!

Tags (2)