SOURCE
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;