DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: triggers for update of a clob?

  1. #11
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    you cannot use comparisons like
    if clob_column_1 = clob_column_2
    use dbms_lob.compare
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  2. #12
    Join Date
    Jun 2003
    Posts
    47
    begin
    if inserting then
    INSERT INTO tblworkingcontentversion (idworkingcontentversion,content,IdWorkingContent,IdUser,MinorVersion, idDocument) values
    (sq_tblwcontvers.nextval,:new.content,:new.idworkingcontent,:new.iduserwhocreate,1,:new.iddocument);
    end if;
    if UPDATING then
    if dbms_lob.compare(:new.content,ld.content,30000,1,1)<>0 then
    INSERT INTO tblworkingcontentversion (idworkingcontentversion,Content,IdWorkingContent,IdUser, idDocument) values
    (sq_tblwcontvers.nextval,:new.content,ld.idworkingcontent,ld.iduserwhocreate,ld.iddocument);
    end if;
    end if;
    end;


    It doesn't work.
    Please if u can write some code it would help so much.
    I want a trigger that triggers when only the content (clob field)
    updates and I am not managing to do that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width