I've two tables BL, SITE and it has the same column ADDRESS1.
How Can I see the same value of column ADDRESS1 in both tables when I insert a new record in table SITE??
I tried this trigger:
CREATE OR REPLACE TRIGGER insert_address1
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
insert into BL (ADDRESS1) values (:new.ADDRESS1);
but when I insert a new record in table SITE I see this error:
ora-01400:cannot insert null into ("bl"."bl_id")
ora-06512: at scott.insert_address1
ora-04088: error during execution of trigger insert_address1
table BL has many columns NOT NULL.
How can I write this trrigger???
and, moreover, if I want modify just the value of ADDRESS1 in table SITE and I want see it in table BL How can I do??
Please do not post the same question to more than one forum.
Click Here to Expand Forum to Full Width