SQL & PL/SQL

HI,

is it possible to use replace function on long data type inside a trigger?

we had enhancement for column to support 6000 characters so we changed the column data type from varchar2 to long.

Tables got altered successfully,but a trigger which uses this column in getting failed while compiling.Is there any other way to handle this replace functionality on long datatype?

example:
select replace(:new.fft_ins_descr ,chr(13),chr(10)) into
l_fft from dual;


here fft_ins_descr is of long data type.

Thanks & regards
Suresh M