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
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
-- fill with data
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.