trigger on clob column
I need to copy a clob column data from table a to table b using a trigger.
I tryed to do it using the syntaxes:
insert into b.clob_column
values (:new.a.clob_column);
insert into b.clob_column
values (empty_clob());
update b set clob_Column = :new.clob_column;
On the two examples, the b.clob_column results null.
How can i do it correctlly?
I,'m using Oracle Database 11g Release 11.1.0.6.0.
Regards.
Luis.