hello i am using this executeStoredProcedureForQuery but I'm not receiving anything in results this SP is SQL i want to get this i tried using the smart service and its the same no values returned
Discussion posts and replies are publicly visible
Personally, I would return a result instead of returning an error. So return code 0 but a result of "Already Exists".
Otherwise, perhaps you could log a case with Appian support to indicate that they seem to be returning a success when the procedure returns a error in SQL Server stored procedures.
I cant change the SP definition , since its used in other systems . well do thank you