Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in RPA by (12.7k 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. 

Thanks in Advance

1 Answer

0 votes
by (29.5k points)

Hi, here's a way that might work for ya

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 parameters as variables like this

sp1('$a1$','$a2$')

a1 and a2 are variables added in variable manager.
If param1 value is integer you can pass it like sp1($param1$,'$param2$').
For string parameter, you need to put
single quote.

Related questions

0 votes
1 answer
asked Jul 22, 2019 in RPA by noah kapoor (5.3k points)
0 votes
1 answer
asked Jul 22, 2019 in RPA by noah kapoor (5.3k points)
0 votes
1 answer

Browse Categories

...