> 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.

I just received email from Vlad Horsun (he does not have account on Yahoo!
groups). He means that the error is not caused by the garbage collector. The
more likely situation is that BLOB is created in one transaction
(connection), but used in another one - temporary BLOB IDs are valid only
there.

This however does not explain how other transaction could obtain those temp
IDs...

Roman