Here is a link that shows the code for a function to replace in a clob.
It parses the CLOB in segments so as to avoid buffer over flow and overlaps the segments to ensure the searched string is not missed.
Oracle 11g’s XML preprocessors now includes a binary XML encoder, decoder and token manager.
Binary XMLType is optimized for storage and retrieval of XML data by reducing memory and CPU demand.
One of its main purposes is to overcome the indexing limitation presented by unstructured and hybrid storage of XML data, that is, CLOB storage.
It does this by indexing the XML tags of your document and identifying document fragments based on XPath expressions that target them.
I will show you how to convert, check and select data from xml files, all the right tools to work with XML in Oracle Database.
XMLQuery lets you construct XML data and query XML and relational data using the XQuery language.
XMLTable lets you create relational tables and columns from XQuery query results.
Once you have the CLOB in the database, you cannot use the XMLDB operators until you have converted the CLOB to an XMLType.
DECLARE l_clob CLOB; xml Doc XMLType; BEGIN --XMLtype function will convert the l_clob and put it into the xml Doc variable.