Trigger

From: Shiv <shiv.hikumar_at_gmail.com>
Date: 6 Nov 2006 05:13:30 -0800
Message-ID: <1162818810.740461.178300@m73g2000cwd.googlegroups.com>

Hi,

I have written a trigger on a server say server2 as below and is working fine,but here i am using empty_blob(),and in server2 i am inserting image also and i want the complete replication on server1 . CREATE TRIGGER IMIGRATION.TR2P_IM_BLIST_IMAGE AFTER INSERT ON IMIGRATION.IM_BLIST_IMAGE FOR EACH ROW BEGIN IF ( INSERTING ) THEN INSERT INTO IMIGRATION.IM_BLIST_IMAGE_at_srv2_to_srv1 VALUES (:new.LOC_PHOTO_SRNO, :new.LOC_SUSPT_SRNO, EMPTY_BLOB(), :new.ENTRY_DATE, :new.USER_ID);

END IF; END; Received on Mon Nov 06 2006 - 07:13:30 CST