"Henry FRANQUET" <henryfranquet@...> wrote in message
news:3C39661C.2915DC1C@......

> Hi,
>
> I have been reported by my clients, database corruption with IB5.6 about
> blob when copying blob in SP.
> When reading ibsupport news I found that one should not use blob copy in
> stored procedure as sometimes it fails in IB5.6 as in IB 6.0
> But what is the workaround ? (I can't change client database)

This issue appears every time you attempt to copy blobs inside a procedure
or trigger. The db becomes corrupted.
It was solved in Firebird months ago. There's no known reliable workaround
inside a procedure.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing