create or replace TRIGGER st_statuts BEFORE INSERT ON statuts FOR EACH ROW BEGIN SELECT s_statuts.nextval INTO :new.p_id FROM dual; END;