Trigger and LONG-datatype

Hi,

i have a Trigger which minutes a table with a LONG-field. The Trigger looks like this:

create or replace trigger gepard.TR_POST_AI_PPOST after insert on gepard.post for each row begin
 if :new.post_typ = 'RE' then
  insert into prot.p_post
  (p_post_post_nr, p_post_gpar_nr, p_post_firm_nr, p_post_fist_nr,   p_post_ntea_nr, p_post_post_text, p_post_post_kennzeichen, p_post_post_version)
  values
  (:new.post_nr, :new.gpar_nr, :new.firm_nr, :new.fist_nr,   :new.ntea_nr, :new.post_text, :new.post_kennzeichen, :new.post_version);  end if;
end;
/

The Trigger minutes all fields exactly, except the LONG-field (:new.post_text). There are no errors or warnings. In the table p_post the field is NULL!

Why? Received on Tue Feb 09 1999 - 08:16:21 CST