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