Help With Triggers

Please help:

While this trigger is created without error in the SCHEMA Manager, my application refuses to validate the code. I am trying to take just a few of the values being inserted into table1 and insert those into table2

CREATE or replace TRIGGER system.event_insert_trig

    BEFORE insert ON system.event
    REFERENCES NEW as new
    FOR each row
BEGIN
    INSERT INTO system.CATALOG_EVENT
    VALUES ( :new.event_id, :new.campaign_id, :new.event_name, :new.event_desc, :new.concept_id, :new.channel_id,

    :new.company_id, 'N' );
END; Jefferson Gallaway
jkgallawy_at_home.com Received on Mon Feb 26 2001 - 22:06:45 CST