楼上的,您好,我的触发器是这么写的,编译没报错,但就是无效,可以帮我看一下吗?CREATE OR REPLACE TRIGGER "FGOG_AVATAR"."TRI_HOMPY_USER_ON_ADD" AFTER INSERT ON "FGOG_AVATAR"."USERX" FOR EACH ROW begin if(:NEW.genderx = '1') then INSERT into FGOG.TBL_HOMPY(user_id, user_name, nick_name, birthday, gender_code, avatar_small) VALUES(SEQ_USER.NEXTVAL, :NEW.loginn, :NEW.nickx, :NEW.birthdayx, '1', 'boy|gir'); else INSERT into FGOG.TBL_HOMPY(user_id, user_name, nick_name, birthday, gender_code, avatar_small) VALUES(SEQ_USER.NEXTVAL, :NEW.loginn, :NEW.nickx, :NEW.birthdayx, '2', 'boy|gir'); end if;end;
INSERT into FGOG.TBL_HOMPY(user_id, user_name, nick_name, birthday, gender_code, avatar_small)
VALUES(SEQ_USER.NEXTVAL, :NEW.loginn, :NEW.nickx, :NEW.birthdayx, '1', 'boy|gir');
else
INSERT into FGOG.TBL_HOMPY(user_id, user_name, nick_name, birthday, gender_code, avatar_small)
VALUES(SEQ_USER.NEXTVAL, :NEW.loginn, :NEW.nickx, :NEW.birthdayx, '2', 'boy|gir');
end if;end;