Re: Updating Relational Data with XML.

LineVoltageHalogen wrote:

> Greetings All, I have been tasked with determining if it is possible to
> update the relational data in our Oracle database using XML. The idea
> is to do mass updates to our database via .NET and C#. The goal is to
> have a stored proc that takes one argument (clob) which contains XML
> data that reflects the data after the update.
>
> E.g)
>
> SET @XmlData ='<?xml version="1.0" encoding="UTF-8" ?>
> <UpdateCustomer>
> <RmCustomer RCusIdPK="1" RSiteIdPK="1000" RCusFName="Vincento">
> </RmCustomer>
> </UpdateCustomer>'
>
>
> This simple XML would update the table RmCustomer, particularly the
> customer with RCusIdPK = 1. Regardless of what RCusFName is now we
> want it to be "Vincento." after the update.
>
> Ideally this simple XML would be passed to a stored proc which would do
> all the work:
>
> exec uspUpdateCust @XmlData
>
> I know this is a broad question but if it is possible I would
> appreciate a jumping off point to get the proc written so that I can
> test.
>
> Any help would be greatly appreciated.
>
> TFD
Possible yes. Advisable is quite another thing entirely.

Why use hundreds of bytes to do what can be done by one with far less overhead and far less i/o?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)