Subject RE: [firebird-support] bug in blob param
Author Alan McDonald
> i tried to do:
> execute procedure tst_blob('test');
> and i got the same error.
> the only workarround i found is to change the param type to varchar like
> this:
> it works, but i am not so happy because the field is a blob.
> thanks, Alan.

you can't pass a varchar to a blob..
you can use the udf to convert a varchar to a blob on the fly if you wish
but it only accepts varchars up to 254 in length.
F_STRBLOB(varchar, blob) will return the varchar in the second parameter