create or replace TRIGGER st_semaines BEFORE INSERT ON semaines FOR EACH ROW BEGIN SELECT s_semaines.nextval INTO :new.p_id FROM dual; END;