Hello,
I have a stored procedure that accepts a XML parameter (@xml). The procedure handles the XML and uses it to process the data (can contain hundreds of items).
It appears that the ODBC Adapter requires the Message Body to be a XML formatted to make the call.
<Statement type="StoredProcedure" sql="{Call uspUpdatePhoneNumber(?)}">
<Parameters>
<Parameter type="varchar" name="@xml" value="<Root><Item><val1>A<val1><val2>123</val2></Item><Item><val1>B</val1><val2>456</val2></Item></Root>"/>
</Parameters>
</Statement>
How can I inject the XML data into this call so it sends the XML parameter to the stored procedure?
This is going against SQL Server. I am unable to figure out 2 things:
1) the SQL XML DataType for ODBC; and
2) how can I pass the XML to the Stored Procedure parameter?
In the Business Process SQL step, this was trivial. The message body (OuterXML) was the XML.
Tags:
This forum post can also be closed.
It appears that this too is not possible to do with the ODBC Adapter in NeuronESB.
Neuron ESB Product Support Forums and Communities
© 2024 Created by Neuron Admin. Powered by