Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

subudhi_pamiset
New Contributor

call/execute stored procedure from Macro

Hi All,

I have a scenario to update the back end oracle database based on the record selected in the table.

Once the user clicks on the button which has macro (it assigns the selected record unique identifier to variable) and it should be able to execute the stored procedure.

I am able to assign the value to variable but failed to call the stored procedure. Is there a way to execute / call the stored procedure from the macro? If so, can you please share the code/steps to achieve this.

Thanks in advance.