Thank you very much pak Izzudin Hanafie ---------- Forwarded message ---------- From: Izzudin Hanafie <[email protected]> Date: 22 Apr 2009 13:29 Subject: Re: [indo-oracle] Buat trigger untuk 2 user yang berbeda To: [email protected]
Pak Nicholas, Sebaiknya event yang digunakan yaitu AFTER INSERT. Bila menggunakan BEFORE INSERT datanya ngga akan masuk ke user2.kar karena triggernya sendiri diletakkan di table user1.tr_kary. CREATE OR REPLACE TRIGGER User1.TR_KARY AFTER INSERT ON User1.kary REFERENCING NEW AS NEW FOR EACH ROW BEGIN Insert Into User2.kary (nik, nama) VALUES (:new.nik, :new.nama) ; END ; Pastikan juga table kary di user2 di grant insert ke user1.. Semoga membantu. Thanks IH --- On Wed, 4/22/09, Nicholasfa AR <[email protected]<nicholasfa%40gmail.com>> wrote: From: Nicholasfa AR <[email protected] <nicholasfa%40gmail.com>> Subject: [indo-oracle] Buat trigger untuk 2 user yang berbeda To: [email protected] <indo-oracle%40yahoogroups.com> Date: Wednesday, April 22, 2009, 1:59 AM Rekan-rekan Oracle User, saya mau coba buat trigger untuk 2 user yang berbeda dengan table yang sama, seperti dibawah ini CREATE OR REPLACE TRIGGER User1.TR_KARY BEFORE INSERT ON User1.kary REFERENCING NEW AS NEW FOR EACH ROW BEGIN Insert Into User2.kary (nik, nama) VALUES (:new.nik, :new.nama) ; END ; Tujuannya adalah pada saat insert table user1.kary di user2.kary juga ikut ter-insert. Mungkin ada yang bisa membantu. Thanks sebelumnya Nicholas [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
