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@srv2_to_srv1 VALUES
(:new.LOC_PHOTO_SRNO, :new.LOC_SUSPT_SRNO, EMPTY_BLOB(),
:new.ENTRY_DATE, :new.USER_ID);



END IF;



END;

Shiv wrote:
Update the BLOB.

Though it seems to me that using AQ might be another solution.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org