How to run postgresql store proc's while passing arguments in AA

@Lesley   here is example for empty parameters but you can use for regular parameters as well

• 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.