create or replace TRIGGER st_evts BEFORE INSERT ON evts FOR EACH ROW BEGIN SELECT s_evts.nextval INTO :new.p_id FROM dual; END;