Subject Re: [ib-support] Firebird, Stored Procedures, and BLOB parameters
Author Jerome Bouvattier

>----- Original Message -----
>From: Alan McDonald
>Sent: Tuesday, March 25, 2003 4:42 AM
>Subject: RE: [ib-support] Firebird, Stored Procedures, and BLOB parameters

>ok - maybe you didn't mean that...
>you didn't correct Robert on his statement...

>"Interbase 6 documentation (since it's the only reference I could find on
>Stored Procedures for Firebird) and it stated that the only types that
>not be input parameter types to stored procedures were ARRAY and BLOB

>but inferred that it was already supported (in Firebird - my assumption)

>PS: I've never read this statement in the documentation but if it's there,
>it's clearly wrong

That's what I thought until I get an "Invalid BLOB id" error. I searched the
borland archives I found posts (such as saying that
the doc what right in the sense that you can't predict if passing BLOB
params will work or not. Bottom line seems to be "it might work, it might

This is true for IB 6 and I learnt it the hard way. Now I searched in FB's
release notes to see if it had been fixed, but found nothing.

Can someone confirm it has been fixed in FB ?