RFC-JDBC-RFC Scenario but the response is not populated the RFC parameter

[former_member193107]

Dear Sir,

I have RFC-JDBC-RFC scenario where I send a parameter using RFC to Stored Procedure in SQL server and then the Stored procedure will response back to RFC.

When I checked the logs message, I can see the XML from the Stored Procedure Response

pic1.png

The problem is that it's not populated the RFC table parameter.

pic2.png

Here's my Mapping for response.

pic3.png

Please advice.

Regards,

Samuel

[PriyankaAnagani · Accepted solution]

Hi Samuel,

As per Pic1 that you shared, the DB response structure is different from the source structure in your mapping. Between "Statement_response" & "row", there is one more node "response_1" because of this it's not populated.

Regards,

Priyanka

[former_member193107 · Accepted solution]

priyanka.anagani Thank you so much, it's working now 🙂