Subject Re: [Firebird-Java] Re: OBJECT in use during Foreign key creation
Author Ann W. Harrison
At 09:42 PM 3/26/2003 +0000, Roman Rokytskyy wrote:

>As you see, BLOB SUB_TYPE 1 does not belong to the list of allowed
>data types. I do not know if this is bug in reference or in syntax
>parser. Ask this in IB-Support.

Actually, this is a difference between InterBase and Firebird (all
versions). There was a bug in handling blobs in procedures that
occasionally cause a double reference to a blob - two records pointing
at the same blob. When one was deleted or modified the blob, the
other was left with a bad pointer. Claudio found and fixed that
problem, so Firebird does allow blobs as parameters and for internal
reference within procedures.


We have answers.