I need help in running store proc’s where I’m passing arguments in the the store proc within the task bot.The parameters have been defined in the store proc when I created it in the DB.The arguments are coming from DB
Page 1 / 1
- In SQL to execute stored procedure with empty parameter as per Microsoft documentation the way is to use value as two single quotes, for example in below stored procedure GetNames we need to pass @MiddleName parameter with no value
exec GetNames @FirstName = 'Rohit' , @MiddleName='', @LastName='Sharma'
- For executing same stored procedure from Automation Anywhere using command "Database: Run stored procedure command" the way to get the correct result is to use a white space in Parameter value.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.