title: Update xml element value in Oracle
body: <p>Having a XMLTYPE column in an Oracle table, I would like to update the values of some xml elements using UpdateXML method but I have troubles doing so because of a namespace which is applied on an xml element which is not parent. The xml structure of my elmenets looks something like:</p>
  
  <pre><code>&lt;a&gt;
    &lt;b xmlns="urn:www.someSite.com/myModel"&gt;
      &lt;c&gt;my value&lt;/c&gt;
    &lt;/b&gt;
  &lt;/a&gt;
  </code></pre>
  
  <p>and an update of the following form it does not work:</p>
  
  <pre><code>UPDATE myTable 
    SET myColumn = UpdateXML(myColumn, '/a/b/c','other value', 'xmlns="urn:www.someSite.com/myModel"');
  </code></pre>