| Sachin Kulkarni 2004-05-19, 2:40 am |
| I am trying to use a stored procedure(let's say SP1) using SQL Adapter in my orchestration. SP1 inserts values in the database and returns result and the ID of newly created row. Normally there would be one row data going into SP1 and one response coming
out of it.
However, if the request contains more that one row, I want SQL Adapter to execute the Stored Procedure multiple times. For example, if following request is sent to SQL Adapter port, it should execute SP1 twice resulting in two rows being inserted in the t
able.
<SP1_Request><row val1="A" val2="B"/><row val1="A1" val2="B1"/></SP1_Request>
I found out that it is possible without any modifications. It successfully stores two rows. however the return xml which I am expecting in following format doesn't work.
<SP_Response><response result="OK" id = "row1"/><response result="OK" id = "row2"/></SP_Response>
My receive operation in Orchestration receives only 1 response element. usually result from the last execution (eg. only "row2" response)
Is there any solution to this problem? or do I need to redesign my Orchestration?
|