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 th
e ID of newly created row. Normally there would be one row data going into S
P1 and one response coming
out of it.

However, if the request contains more that one row, I want SQL Adapter to ex
ecute the Stored Procedure multiple times. For example, if following request
 is sent to SQL Adapter port, it should execute SP1 twice resulting in two r
ows 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 s
tores two rows. however the return xml which I am expecting in following for
mat 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. usua
lly result from the last execution (eg. only "row2" response)

Is there any solution to this problem? or do I need to redesign my Orchestra
tion?

[ Post a follow-up to this message ]

SQL Adapter does not support currently multiple outputs. Sorry for
inconvenience.
Thanks
Puru

This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

[ Post a follow-up to this message ]