CREATE OR REPLACE TRIGGER "CESTONLINE"."TR_HLPDSK_LDRS_MLIST" AFTER INSERT ON "CESTONLINE"."T_MLIST" FOR EACH ROW DECLARE mlist_wusr_id number; BEGIN SELECT wusr_id INTO mlist_wusr_id FROM t_webuser WHERE wusr_email = 'user1'; IF mlist_wusr_id IS NOT NULL THEN INSERT INTO t_usermlist (USERMLIST_ID, USERMLIST_MLIST_ID, USERMLIST_WUSR_ID) VALUES (seq_usermlist.nextval, :new.mlist_id, mlist_wusr_id); END IF; SELECT wusr_id INTO mlist_wusr_id FROM t_webuser WHERE wusr_email = 'user2'; IF mlist_wusr_id IS NOT NULL THEN INSERT INTO t_usermlist (USERMLIST_ID, USERMLIST_MLIST_ID, USERMLIST_WUSR_ID) VALUES (seq_usermlist.nextval, :new.mlist_id, mlist_wusr_id); END IF; END; /