Skip to Main Content

trigger

user543623Feb 16 2012 — edited Feb 17 2012
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.
Comments
Post Details
Added on Feb 16 2012
3 comments
78 views