Name Value
OWNER AREL
TRIGGER_NAME T_CRENEAUX_1
TRIGGER_TYPE BEFORE EACH ROW
TRIGGERING_EVENT INSERT OR UPDATE
TABLE_OWNER AREL
BASE_OBJECT_TYPE TABLE
TABLE_NAME CRENEAUX
COLUMN_NAME null
REFERENCING_NAMES REFERENCING NEW AS NEW OLD AS OLD
WHEN_CLAUSE null
STATUS ENABLED
DESCRIPTION t_creneaux_1 BEFORE INSERT OR UPDATE ON creneaux FOR EACH ROW
ACTION_TYPE PL/SQL
TRIGGER_BODY DECLARE compte number; groupe_impossible EXCEPTION; BEGIN SELECT COUNT(g.p_id) INTO compte FROM groupes g, types_groupes tg WHERE g.p_id = :new.pf_apprenants AND tg.p_id = g.f_type AND tg.libelle = 'groupe'; IF (compte != 1) THEN RAISE groupe_impossible; END IF; END;
CREATED 2011-09-02 09:27:09.0
LAST_DDL_TIME 2011-09-02 09:27:09.0