on May 19, 2017Requirement is to send proper message to end user when the stored procedure is executed successfully but records not updated in the application database.
Application Team willing to give error code and error message to handle such scenarios. Can we achieve this using output parameter successfully in SQL & Oracle based AFX Connectors?
Yes, I thought so.
Can we have this workaround, if application team maintains the error dictionary in any of the table in their database, whenever there is an error, by giving some constraint in the sql select node, we will pick the description and send it across to the end user.
it really is sad that most connectors have the return message hard coded. this is true for the database and the SSH adapters. Being able to return a message to the workflow would be awesome.
E.g. what if a provisioning command failed but it was "just" a "overloaded endpoint, try again later" or a "account sync not finished". something like that. One could then wait and loop back, retrying another time.
In a different post, Dan described the functionality around the output parameter:
https://community.rsa.com/thread/191645#comment-891862
Not sure you can use the output parameter feature for that purpose.