Subject | Re: UDFs returning BLOB cause error -804 |
---|---|
Author | mircostange |
Post date | 2002-02-27T11:31:46Z |
> Yes, it's the right place. :))declare your
>
> -804 is returned when you call an unknown function...did you
> 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