> 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:
>
> CREATE PROCEDURE TST_BLOB (TEXT VARCHAR (100))
>
> 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
(blob)

Alan