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)

There is different case in using blob copy (not exhaustive) :
1) insert into table1 (blob1) select blob1 from table1 where ...
(same table)
2) insert into table1 (blob1) select blob2 from table2 where ...
(different table)
3) declare variable var
blob; (using local
variable)
select blob1 fromt table1 into :var;
insert into table2 (blob2) values (:var) where ...

Does one syntax work ? or another one ?
Is the problem the same whatever the type of blob (text or picture) ?
Does trigger have the same problem ?

thanks