Sep 16, 2009 05:36 AM|giles.hinton|LINK
What database are you using?
Both Oracle and SQL server support parsing of XML natively in a procedure / package call.
I've done this in the past - rather than making multiple stored procedure calls, you can perform bulk operations via simple XPath queries to the XML document / fragment you pass to the prcoedure.
It's fast and efficient and will probably outperform multiple calls from the middle tier.