>>Is it ok to pass (and return) blobs to stored procedures in FB1.5.2?
>
> Yes, as ever.
>
>
>>I remember reading something way back about them not working in PSQL.
>
> What doesn't work is to declare a blob as an input parameter in a SP and
> then pass a string parameter to it.

What also doesn't work is accessing the blob's contents inside SP. Something like

create procedure p returns(r varchar(10)) as
declare B blob sub_type text;
begin
select rdb$procedure_source from rdb$procedures where rdb$procedure_name='PX' into :B;
if (B CONTAINING 'alfa') then r = 'YES'; else r = 'NO';
end

when executing it will raise exception
- Statement failed, SQLCODE = -902
- internal error

Ivan