create or replace TRIGGER st_reponses BEFORE INSERT ON reponses FOR EACH ROW BEGIN SELECT s_reponses.nextval INTO :new.p_id FROM dual; END;