Subject Re: [firebird-support] Blob parameters to stored procedures
Author Ivan Prenosil
>>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;
select rdb$procedure_source from rdb$procedures where rdb$procedure_name='PX' into :B;
if (B CONTAINING 'alfa') then r = 'YES'; else r = 'NO';

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