On 06.06.2014 15:11, Mike Ro miker...@gmail.com [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
  • [f... miker...@gmail.com [firebird-support]
    • ... Mike Ro miker...@gmail.com [firebird-support]
      • ... Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
        • ... Mike Ro miker...@gmail.com [firebird-support]
        • ... Mike Ro miker...@gmail.com [firebird-support]
          • ... Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
            • ... Mike Ro miker...@gmail.com [firebird-support]
              • ... Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
                • ... Mike Ro miker...@gmail.com [firebird-support]
                • ... Olivier Mascia o...@tipgroup.com [firebird-support]
                • ... Mike Ro miker...@gmail.com [firebird-support]
                • ... Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
                • ... Mike Ro miker...@gmail.com [firebird-support]
                • ... Olivier Mascia o...@integral.be [firebird-support]
                • ... Mike Ro miker...@gmail.com [firebird-support]

Reply via email to