INSERT AUTOMATIC

HI,
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
AFTER INSERT
ON SITE
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
Begin
insert into BL (ADDRESS1) values (:new.ADDRESS1);
end;

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??

Thanks

Raf

Please do not post the same question to more than one forum.

http://www.dbasupport.com/forums/sho...threadid=29051

Thanks,

- Chris

spamming again?

geez