我正在写以下oracle sql触发器

CREATE OR REPLACE TRIGGER scheme1.INSERTING_TRIGGER AFTER INSERT  ON scheme1.Bill
    FOR EACH ROW
    BEGIN
    INSERT INTO scheme2.DM_LOGGER(ID, TECHNOLOGY, WORKFLOW, NAME_EVENT, TIME_EVENT)
    VALUES(scheme1.Bill.id,'Repository','UP','Accepted', SYSDATE);   
    END;

最佳答案

您需要使用NEW记录:

CREATE OR REPLACE TRIGGER scheme1.INSERTING_TRIGGER AFTER INSERT  ON scheme1.Bill
    FOR EACH ROW
    BEGIN
    INSERT INTO scheme2.DM_LOGGER(ID, TECHNOLOGY, WORKFLOW, NAME_EVENT, TIME_EVENT)
    VALUES(:NEW.id,'Repository','UP','Accepted', SYSDATE);   
    END;

关于oracle - 错误(3,31): PL/SQL: ORA-00984: Column is not allowed here，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/29771474/