trigger
Hi,
1.
CREATE OR REPLACE FORCE VIEW FSDBA.MYVIEW1
(
LU10,
NRISCN,
NRISASPCN,
V_CN,
V_HRCT,
V_HRSC
)
AS
SELECT lu10.cn,
nris.lucn,
nris.aspectCN,
VLUKUP.SEQCN,
VLUKUP.HRSCT,
VLUKUP.HRSC
FROM lu10, nris, vLukUp;
2.
CREATE OR REPLACE TRIGGER FSDBA.myview1_trigger
INSTEAD OF INSERT or update
ON MYVIEW1 REFERENCING NEW AS NEW OLD AS OLD
declare
BEGIN
insert into lu10 ( cn )
values (:new.cn);
INSERT INTO nris
VALUES (:new.lucn, :new.aspectCN);
INSERT INTO vLukUp
VALUES (:new.seqCN, :new.hrsc, :new.hrsct);
END myview1_trigger;
/
when i run trigger, i get error as
[Error] PLS-00049 (12: 9): PLS-00049: bad bind variable 'NEW.CN'
[Error] PLS-00049 (16: 16): PLS-00049: bad bind variable 'NEW.LUCN'
[Error] PLS-00049 (16: 27): PLS-00049: bad bind variable 'NEW.ASPECTCN'
[Error] PLS-00049 (19: 16): PLS-00049: bad bind variable 'NEW.SEQCN'
[Error] PLS-00049 (19: 28): PLS-00049: bad bind variable 'NEW.HRSC'
[Error] PLS-00049 (19: 39): PLS-00049: bad bind variable 'NEW.HRSCT'
Please advise.
Thanks.