LONG fields inside a trigger.

Hi. Is it at all possible to do something like:

CREATE TRIGGER ...
 INSERT INTO some_other_table (long_field)  VALUES ('string A'||:new.this_long_field||'string B');

I've tried near anything - reading the new long field into a cursor long variable which was illegal (mutating table), reading it from a view - same deal. The above technique results in a "ORA-03113: end-of-file on communication channel" on 8.1.6.1.

So, is there any way AT ALL, inside a trigger, to stream/insert the updated LONG value of a table into another table? I have to be able to modify it slightly, ie. wrap it in tags like '<datablock>'||longField||'</datablock>' which is usually legal with LONGs in PL/SQL. I'm awfully stuck, any help greatly appreciated.

Morten

-- 
Morten Primdahl         Caput A/S       Tel +45 70 12 24 42
morten_at_caput.com        Nygade 6        Fax +45 70 11 24 42
http://www.caput.com/   DK-1164 Kbh K