I am trying to add a logging facility to an application I am working
on which will keep the history of blobs. The problem is that I want to
throw an error when the :NEW.BLOB_FIELD is empty - ie When
DBMS_LOB.GETLENGTH is 0. However the data always returns 0 in the
After Update trigger - making my task seem impossible at the moment. I
can get it for the OLD value - but not the new one (which is no use to
me - it's too late when the blob field is empty already)

Regards

Neil Danson