Hi
I'm trying top update multiple rows with the Microsoft BizTalk Adapter for
Oracle Database. I have a number of rowids and want to change their
'Status'
value all at once. Is it not possible to do this with the updatepart of
the
xsdschema? Or do i have to loop all the IDs one by one in the
orchestration
itself?
I have tried to work it out with a stored procedure, but have had some
problems with this.
I imagine it to look something like this but cant work out the map:
</ns0:Record>
<ns0:STATUS>1</ns0:STATUS>
</ns0:Record>
<ns0:Filter>ID=1</ns0:Filter>
</ns0:Record>
<ns0:STATUS>1</ns0:STATUS>
</ns0:Record>
<ns0:Filter>ID=2</ns0:Filter>
I have come as far as getting this output which only update one record:
</ns0:Record>
<ns0:STATUS>1</ns0:STATUS>
</ns0:Record>
</ns0:Record>
<ns0:STATUS>1</ns0:STATUS>
</ns0:Record>
<ns0:Filter>ID=1</ns0:Filter>
<ns0:Filter>ID=2</ns0:Filter>
Is this possible at all?
