Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using replace in a clob

Re: Using replace in a clob

From: Mike Cretan <nospamthanks_at_nowhere.com>
Date: Wed, 23 Mar 2005 22:14:48 GMT
Message-ID: <sTl0e.9267$C7.7935@news-server.bigpond.net.au> 





Yeah, CLOBS are a pain in 8i.



One approach you could use is to process it in chunks as you suggested, but 
instead of a fixed size of 32K, check for the existence of an "open 
substitute section" indicator (e.g. '<!-') within a 1000 characters of the 
32K mark, and break your chunks up so that they don't cross a substitution 
section.



Mike 
Received on Wed Mar 23 2005 - 16:14:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US