| BLOB can not replicate on the Network. [message #120362] |
Thu, 19 May 2005 05:05 |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
Can not replicate BLOB on the Network.
Here is my table script and Trigger Code.
create table StoredImages
( imageid number,
imagecontainer blob);
create table copy_StoredImages
as select * from StoredImages;
CREATE OR REPLACE TRIGGER "REPLICATE_storedImage"
AFTER INSERT OR DELETE OR UPDATE
OF imageid ON StoredImages
REFERENCING NEW AS N OLD AS O
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO COPY_StoredImages@DB_LINK (imageid, imagecontainer)
VALUES (:N.imageid, :N.imagecontainer);
ELSIF UPDATING THEN
UPDATE COPY_StoredImages@DB_LINK
SET imageid = :N.imageid,
imagecontainer = :N.imagecontainer
WHERE imageid =  .imageid;
ELSIF DELETING THEN
DELETE FROM COPY_StoredImages@DB_LILNK
WHERE imageid = .imageid;
END IF;
END;
/
I want to replicate BLOB (Picture) Data on the network. Through is database trigger i am trying to replicate the data in another database on the network.All data is replicated but picture data is not replicated. How can i do replicate picture data on the network.
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
