title: Replacing text in a BLOB Column
body: <p>In one of our tables we have a <code>HUGEBLOB</code> Column (Column name is <code>DYNAMIC_DATA</code>) which holding an XML data. What I need to do is updating a certain part of the text from within this BLOB.</p>
  
  <p>I've tried this query:</p>
  
  <pre><code>UPDATE ape1_item_version 
  SET DYNAMIC_DATA = REPLACE (DYNAMIC_DATA,'Single period','Single period period set1') 
  WHERE name = 'PRIT ALL POOL for Duration Telephony 10_NA_G_V_H_N_Z2'
  </code></pre>
  
  <p>But I get the following error:</p>
  
  <p><code>ORA-00932: inconsistent datatypes: expected NUMBER got BLOB</code></p>
  
  <p>How can I execute <code>REPLACE</code> on the BLOB ?</p>