find/replace on long field

From: Hugh <hughmclaughlin_at_gmail.com>
Date: 26 Oct 2006 12:53:50 -0700
Message-ID: <1161892429.832892.284930@m73g2000cwd.googlegroups.com>

I have a table where I am searching for text in a long field to be replaced in Oracle 8.

I have created something like

update table_tbl
set FIELD =
replace(FIELD,'text_to_be_Replaced','new_text_to_be_inserted') where FIELD like '%'||'text_to_be_Replaced'||'%'

but that does not work since you can not run an oracle function on a Long field. Since this database works with 3rd party software, changing the field to a CLOB is not a viable option.

any recommendations? Received on Thu Oct 26 2006 - 14:53:50 CDT