Thanks for your answer. Yes, I was running in that mode !
But it seems to me nearly impossible that another transaction could
delete the record in that moment ( because of the business logic, those
record aren't deleted until the end of the day ). But I'll continue to
investigate ...

Thanks again,
Aldo

El 14/01/11 13:13, Ann W. Harrison escribió:

>
> On 1/14/2011 9:56 AM, Aldo Caruso wrote:
> > After executing a stored procedure which selects records from a table, I
> > received this error:
> >
> > Error code -901: 'conv_out_blob_materialized.isc_open_blob2: BLOB
> not found'
> >
>
> If you're running in READ COMMITTED READ ONLY mode, it means that
> the procedure read a record with blob data, but by the time it went
> back to get the blob, some other transaction had deleted the record
> and committed and a third transaction garbage collected the record
> and its blobs.
>
> If you're running in another mode, you may have found a Firebird bug.
>
> Good luck,
>
> Ann
>
>

[Non-text portions of this message have been removed]