CREATE OR REPLACE TRIGGER TRG_NAME
BEFORE INSERT ON T_NAME
FOR EACH ROW
DECLARE V_ID NUMBER;
BEGIN
SELECT TO_CHAR(FWDB.YW_CBGK_SEQ.NEXTVAL) INTO :NEW.V_ID FROM DUAL;
END TRG_NAME; 这样就肯定没有错误!
BEFORE INSERT ON T_NAME
FOR EACH ROW
DECLARE V_ID NUMBER;
BEGIN
SELECT TO_CHAR(FWDB.YW_CBGK_SEQ.NEXTVAL) INTO :NEW.V_ID FROM DUAL;
END TRG_NAME; 这样就肯定没有错误!
BEFORE INSERT ON T_NAME
FOR EACH ROW
DECLARE V_ID NUMBER;
BEGIN
SELECT TO_CHAR(FWDB.YW_CBGK_SEQ.NEXTVAL) INTO :NEW.V_ID FROM DUAL;
END TRG_NAME;----------------------------------
BEFORE换成AFTER,下边的查询语句就错了
AFTER INSERT ON T_NAME
FOR EACH ROW
DECLARE V_ID NUMBER;
BEGIN
SELECT TO_CHAR(FWDB.YW_CBGK_SEQ.NEXTVAL) INTO :NEW.V_ID FROM DUAL;
END TRG_NAME;我遇到了这么个问题,请问如何解决?
通常:new仅仅在行级别前的触发器中被修改