Subject Re: UDFs returning BLOB cause error -804
Author mircostange
> Yes, it's the right place. :))
>
> -804 is returned when you call an unknown function...did you
declare your
> functions to the database?
>

Yes, I did. There is a free udf lib that has a strblob function. As I
understand, it's supposed to take a string and return a blob. I
declared it with

declare external function f_StrBlob
cstring(254),
blob
returns parameter 2
entry_point 'StrBlob' module_name 'FreeUDFLib.dll';


However, when I try to execute:

select f_strblob('X') from sampletype


I get the following error:

Dynamic SQL Error
SQL error code = -804
SQLDA missing or incorrect version, or incorrect number/type of
variables
Statement: select f_strblob('X') from sampletype

Anything I don't do right? Can't blobs be returned like this?
Ah and yes, the dll is in Firebird/udf.

Mirco