是一个自动生成序列号的trigger,但是数据库中找不到和lfnr相关的内容(表,视图)。 这个lfnr应该是个什么东东?
CREATE TRIGGER "G90CM"."CKUKA_NEXTLFNR"
BEFORE INSERT
ON G90cm.ckuka_serialnr
REFERENCING OLD AS OLD
NEW AS NEW
FOR EACH ROW
BEGIN
Select lfnr_serialnr.nextval into :NEW.lfnr from dual ;
END;
CREATE TRIGGER "G90CM"."CKUKA_NEXTLFNR"
BEFORE INSERT
ON G90cm.ckuka_serialnr
REFERENCING OLD AS OLD
NEW AS NEW
FOR EACH ROW
BEGIN
Select lfnr_serialnr.nextval into :NEW.lfnr from dual ;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货