是:new.series=nextvalue;了 但是一个create trigger是可以执行的,但两个create trigger 防在一起就不可以了 如:CREATE SEQUENCE SELLMANAGE.SEQ_AllotSlipHead_tmp_Series INCREMENT BY 1 START WITH 1125 MAXVALUE 999999999 MINVALUE 1 CYCLE CACHE 20 ORDER ;CREATE OR REPLACE TRIGGER SELLMANAGE.TRG_AllotSlipHead_tmp_SERIES BEFORE INSERT ON SELLMANAGE.AllotSlipHead_tmp FOR EACH ROW declare nextvalue integer ; BEGIN select SEQ_AllotSlipHead_tmp_Series.nextval into nextvalue from dual ; :new.Series:=nextvalue; END; 执行没有问题,但是CREATE SEQUENCE SELLMANAGE.SEQ_AllotSlipHead_tmp_Series INCREMENT BY 1 START WITH 1125 MAXVALUE 999999999 MINVALUE 1 CYCLE CACHE 20 ORDER ;CREATE OR REPLACE TRIGGER SELLMANAGE.TRG_AllotSlipHead_tmp_SERIES BEFORE INSERT ON SELLMANAGE.AllotSlipHead_tmp FOR EACH ROW declare nextvalue integer ; BEGIN select SEQ_AllotSlipHead_tmp_Series.nextval into nextvalue from dual ; :new.Series:=nextvalue; END;CREATE SEQUENCE SELLMANAGE.SEQ_AnAPDABA_Series INCREMENT BY 1 START WITH 1 MAXVALUE 999999999 MINVALUE 1 CYCLE CACHE 20 ORDER ;CREATE OR REPLACE TRIGGER SELLMANAGE.TRG_AnAPDABA_SERIES BEFORE INSERT ON SELLMANAGE.AnAPDABA FOR EACH ROW declare nextvalue integer ; BEGIN select SEQ_AnAPDABA_Series.nextval into nextvalue from dual ; :new.Series:=nextvalue; END;就出现错误,把两个分开就没有问题,放在一起就有问题,是;号的分割引起的,怎么解决呀?
但是一个create trigger是可以执行的,但两个create trigger 防在一起就不可以了
如:CREATE SEQUENCE SELLMANAGE.SEQ_AllotSlipHead_tmp_Series INCREMENT BY 1 START WITH 1125 MAXVALUE 999999999 MINVALUE 1 CYCLE CACHE 20 ORDER ;CREATE OR REPLACE TRIGGER SELLMANAGE.TRG_AllotSlipHead_tmp_SERIES
BEFORE INSERT ON SELLMANAGE.AllotSlipHead_tmp FOR EACH ROW declare nextvalue integer ;
BEGIN
select SEQ_AllotSlipHead_tmp_Series.nextval into nextvalue from dual ;
:new.Series:=nextvalue;
END;
执行没有问题,但是CREATE SEQUENCE SELLMANAGE.SEQ_AllotSlipHead_tmp_Series INCREMENT BY 1 START WITH 1125 MAXVALUE 999999999 MINVALUE 1 CYCLE CACHE 20 ORDER ;CREATE OR REPLACE TRIGGER SELLMANAGE.TRG_AllotSlipHead_tmp_SERIES
BEFORE INSERT ON SELLMANAGE.AllotSlipHead_tmp FOR EACH ROW declare nextvalue integer ;
BEGIN
select SEQ_AllotSlipHead_tmp_Series.nextval into nextvalue from dual ;
:new.Series:=nextvalue;
END;CREATE SEQUENCE SELLMANAGE.SEQ_AnAPDABA_Series INCREMENT BY 1 START WITH 1 MAXVALUE 999999999 MINVALUE 1 CYCLE CACHE 20 ORDER ;CREATE OR REPLACE TRIGGER SELLMANAGE.TRG_AnAPDABA_SERIES
BEFORE INSERT ON SELLMANAGE.AnAPDABA FOR EACH ROW declare nextvalue integer ;
BEGIN
select SEQ_AnAPDABA_Series.nextval into nextvalue from dual ;
:new.Series:=nextvalue;
END;就出现错误,把两个分开就没有问题,放在一起就有问题,是;号的分割引起的,怎么解决呀?