Name | Value |
---|---|
OWNER | AREL |
TRIGGER_NAME | T_SALLES |
TRIGGER_TYPE | BEFORE EACH ROW |
TRIGGERING_EVENT | INSERT OR UPDATE |
TABLE_OWNER | AREL |
BASE_OBJECT_TYPE | TABLE |
TABLE_NAME | SALLES |
COLUMN_NAME | null |
REFERENCING_NAMES | REFERENCING NEW AS NEW OLD AS OLD |
WHEN_CLAUSE | null |
STATUS | ENABLED |
DESCRIPTION | t_salles BEFORE INSERT OR UPDATE ON salles 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.f_site AND tg.p_id = g.f_type AND tg.libelle = 'site'; 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 |