I am trying to execute sql server procedure from qlikview. The procedure takes 2 parameters as input and returns and array of 3*3 i.e 3 colums and 3 rows.
The script executes without error when I just submit the input parameters and dont specify the output variables to hold the output data. In this case I am not sure whether my procedure is executed or not? How to verify whether procedure is executed or not?
when I declare variables to hold the output data and use them when calling the procedure it gives me an error 'TOO MANY ARGUMENTS FOR THE PROCEDURE OR FUNCTION'