MS SQL Stored Procedures with Return Codes

[akpuvvada]

This is a SAP BTP CPI iFLow JDBC Adpater related question.

We have a Stored Procedure in MS SQL DB.

In addition to regular output parameters and result-sets, it also return a code (Return Code). This RetunrCode concept is specifically only available in MS SQL DB as far as I know.

The execution/SQL Statement to capture the return code is --> 

? = {StoredProcName} (?, ?, ?, ......);

In the above SQL Statement, the all the '?' (either input or output or in/out parameters) that are in brackets, I know how to handle as it is clearly mentioned in documentation.

However, the first '?' which is supposed to capture the Return Value, I am not sure how to handle that.

I tried the below:

1. Add an additional output parameter as first one in the Request XML. Did not work, threw error saying number of parameters did not match.
2. Just sent as many parameters as there are in the brackets with respective fields details. Did not work, threw error saying parameter '0' details/value not set.

I need the return value to be captured in the JDBC Adapter response as the Business logic in further process depends on it. If the value is 1, need to raise an exception and send email to business.

Appreciate if anyone can help how to use JDBC Adapter to invoke the Stored Procedure successfully and capture the Return Code.