0 votes
1 view
in RPA by (5.3k points)

I did not find how to make use of add parameter when we use DB-sql commands in the process of using run stored procedure in AA client widget. I used the parameter but could not find where to assign value to this parameter in the wizard. Please share an example if possible with snapshot.

Thanks in Advance

1 Answer

0 votes
by (9.5k points)

you should run stored procedure, and export to csv file.

Stored Procedure:

ALTER PROCEDURE [dbo].[sp1] ( @p1 VARCHAR(50), @p2 INT )

You can take database command and select “Run Stored Procedure” In procedure name you can pass parameter as variable like this


a1 and a2 are variables added in variable manager. (right side menu of client editor widget)

If param1 value is integer you can pass it like sp1($param1$,'$param2$').

For string parameter you need to put single quote.

($a1$ is variable, 2 is fix integer value: p1 will get value of a1, p2 will get 2)

enter image description here

Related questions

0 votes
1 answer
asked Jul 22, 2019 in RPA by noah kapoor (5.3k points)
0 votes
1 answer
asked Jul 17, 2019 in RPA by Abhishek_31 (12.8k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !