changing charakters in long-datatypes

hi,

i want to change some charakters in a entity (e.g. replace all chr(13) with chr(10)) which is of type long. but for that type, functions like REPLACE, SUBSTR, ... don't work.
can someone help me on this issues.
notice, that this has to be done directly in oracle with without using selfwritten functions or even a script (pl/sql, c, perl, ...)

regards, harald Received on Mon Oct 23 2000 - 07:42:05 CDT