On 06.06.2014 15:11, Mike Ro miker169@... [firebird-support] wrote:

> Frank, thank you for taking the time to do this. It confirms that there is definitely something wrong with my setup (are you using Firebird version 2.5.2?).

No, its LI-T3.0.0.31151 Firebird 3.0 Alpha 2, but that should not matter

> Could you also share your table definition, especially what indexes or
> constraints you have defined as I wonder if this is causing the
> exception? Also do you have anything special in your firebird.conf?
> .ddd,_._,___
>

Nothing special here, it only contains raw weather data, I just added
the blob reading UDF for testing.

This is probably the cause of the exception:

> declare external function f_insertblob cstring (20), blob returns int by
> value entry_point 'insertblob' module_name 'test_udf.so';

should be

DECLARE EXTERNAL FUNCTION f_insertblob CSTRING(255), BLOB RETURNS
PARAMETER 2
entry_point 'insertblob' module_name 'test_udf.so'


The function expects to get a blobcallback structure from the server,
"returns parameter 2" lets the engine provide it.


Frank