| :NEW.columnname is soprting in Oracle 9i R 2 for picture data. [message #120182] |
Wed, 18 May 2005 04:18 |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
:NEW.columnname is sporting in trigger for picture data replication. Check my code where is problem.
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 (imageid, imagecontainer)
VALUES (:N.imageid, :N.imagecontainer);
ELSIF UPDATING THEN
UPDATE COPY_StoredImages
SET imageid = :N.imageid,
imagecontainer = :N.imagecontainer
WHERE imageid =  .imageid;
ELSIF DELETING THEN
DELETE FROM COPY_StoredImages
WHERE imageid = .imageid;
END IF;
END;
Through this trigger i want to replicate picture data in Copy_StoredImages all data is replicate but picture data is not replicate, Is there is any error in my trigger. Is there is another way to replicate picture data. please help me it is Very Urgent.
Thanks
Sohail.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
