Problem building a trigger using a BLOB field in Oracle 10
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Problem building a trigger using a BLOB field in Oracle 10

  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Problem building a trigger using a BLOB field in Oracle 10

    My case is the following,

    I'm trying to implement an AFTER trigger which uses the :new.blob_field to insert the new value in a table. Because of the documented AFTER restriction and :new use for blob fields, I've though to add other BEFORE trigger that calls a procedure in which I can store the :new value and later insert the temporary value in the table when the AFTER trigger is executed.

    The Idea is the following:

    BEFORE trigger :new -> TEMP

    and then

    AFTER trigger uses TEMP to store in the new table

    So, the final questions are the following:
    -Any other idea to do the same, that is, to use the ":new" value in an AFTER trigger?

    -How can I do this with the temp variable, is this correct?:

    PROCEDURE store_blob ( new_val BLOB ) IS


    BEGIN

    DBMS_LOB.CREATETEMPORARY(new_blob_temp,TRUE, DBMS_LOB.SESSION);
    -- fill with data
    DBMS_LOB.COPY (new_blob_temp,new_val,DBMS_LOB.GETLENGTH(new_val),1,1);

    END store_blob ;


    Because of the design of the application I have to use the AFTER trigger to store the new value so I must find a solution for this type of fields.

    Sorry for the size of the text and also for my english.

    Thanks in advance

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    How do you handle if the LOB is more than 32K size?

    Tamil

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