> Is there any chance the blob was deleted before the insert completed?
> The scenario I see is if you do an INSERT INTO ... SELECT ...
> There is a discussion on the Architect list right now about the problem
> where Blobs are garbage collected while they are still in use.

Then you have answered on your question, didn't you? :)

Yes, this is possible, otherwise nobody would discuss possible fixes without
changing the ODS to include it in Firebird 2.0. This applies for READ
COMMITTED isolation level, so switching to REPEATABLE READ should solve this
problem (though it might not fit your application).

Roman