oracle - 错误(3,31): PL/SQL: ORA-00984: Column is not allowed here

Question

我正在写以下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;

并引发以下错误:

错误(2,1):PL/SQL:忽略了SQL语句

错误(3,31):PL/SQL:ORA-00984:此处不允许使用该列。

如果我的猜测是正确的，则问题出在DM_LOGGER的ID列中。
但是我不确定这是怎么回事。我只想从记录器中自动插入新Bill记录中的id。

Answer 1

您需要使用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;

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/triggers.htm#LNPLS99955