CREATE SEQUENCE SEQU_DATA_DATaiNFO INCREMENT BY 1 START WITH 1 NOCYCLE NOCACHE NOORDER;

create or replace TRIGGER TRIG_test
BEFORE INSERT ON TABLE1
FOR each ROW
DECLARE
tmpVAR NUMBER;
BEgin
tmpvar := 0;
Select SEQU_PROC_ASSOCIATeiNFO.NextVal into tmpVar From dual;
:new.procid:=tmpVar;
EXCEPTION
WHEN OTHERS THEN
-- Consider LOGging the error and then re-raise
RAISE;
END;