Shiv wrote:
> 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;
Update the BLOB.
Though it seems to me that using AQ might be another solution.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Nov 06 2006 - 12:12:57 CST
