trigger syntax for after insert

Giganews Newsgroups
Subject: trigger syntax for after insert
Posted by:  Alen Cappelletti (alen.cappellet…@gmail.com)
Date: Mon, 02 Jul 2007

Hi all,
the sysntax above is correct? 'Cause when I compile a got an error...
TNKS Alen

CREATE OR REPLACE TRIGGER AFT_IN_TEAMS
AFTER INSERT ON TEAMS

BEGIN
  IF :NEW.Privato = 1 THEN
    INSERT INTO TEAMCOMPOSIZIONI (IDTEAMRIFERITO,IDTEAM) VALUES (
        :NEW.IDTEAM,
        :NEW.IDTEAM
    ;
  END IF;
END;
/

Replies