Replacing a string within a CLOB - Oracle 9i

[Bowser]

Hi

I recently had a similar problem and found the link below to be useful. It mimics the replace function for clob columns.

http://www.astral-consultancy.co.uk/...doco.cgi?11080

Hope this helps

The code in this example is faulty. Try to reduce the work amount from 32767 to 5 (to better visualize the error), and set the following values:
p_clob '123456789012345678901234567890'
p_what '7'
p_with 'A'

The result will be '1234556A8901233456AA8901234556A890' - not quite correct as the last character of each part is repeated.