Hello,
What we understand, you have created a stored procedure with mentioned SQL commands and are calling it from Automation Anywhere using 'Run Stored Procedure' Database command. Please correct if we are wrong.
In this case, unfortunately, currently 'Run Stored Procedure' Database command does not return value(s) however, the upcoming version (will release shortly) does support this feature. To get around this issue, you can log the return value to a text file, from where Automation Anywhere can fetch the results.
Hope that helps.
|