| trigger: after update on materialized view [message #324047] |
Fri, 30 May 2008 07:16  |
adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo
|
Member |
|
|
Hello. I'm facing the next problem:
i want to create "on update" database trigger on materialized view which is on replication schema.
I would like to update rows in table when update occurs on materialized view on master side.
I wrote some code and tried with this:
CREATE OR REPLACE TRIGGER a
after update on A@dirfep.us.oracle.com
FOR EACH ROW
BEGIN
IF ((:old.b != :new.b) OR (:old.c != :new.c)) THEN
update pr_prim_pos set c1=:new.c,d=:new.d1,e1=:new.e
where c1=:old.c;
END IF;
END a;
Thank you in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
