Subject | UDF Failure |
---|---|
Author | iananewby |
Post date | 2002-03-26T14:23:48Z |
Hi All,
Environment: Windows XP, Firebird 1.0rc2 Dialect 1
I have a udf written in c which is cross platfor
m (linux,windows). Its been working fine on both interbase 6,
firebird 0.94, 1.0RC2.
Now however, if i try and access one of the functions from isql I
get:
SQL> select string_to_blob('th') from rdb$database;
STRING_TO_BLOB
=================
Statement failed, SQLCODE = -804
Dynamic SQL Error
-SQL error code = -804
-SQLDA missing or incorrect version, or incorrect number/type of
variables
The definition returned by idql is:
SQL> show function string_to_blob;
Function STRING_TO_BLOB:
Function library is wmudflib
Entry point is fn_string_blob
Argument 1: CSTRING(32000) CHARACTER SET NONE
Returns BLOB
The only thing that has changed is the database has been recreated
by extracting the metadata (from idql) and recreating it from the
script.
The portion of the script is as follows:
DECLARE EXTERNAL FUNCTION STRING_TO_BLOB
CSTRING(32000) CHARACTER SET NONE, BLOB
RETURNS PARAMETER 2
ENTRY_POINT 'fn_string_blob' MODULE_NAME 'wmudflib';
The only difference from my original script to add the functions is
the CHARACTER SET NONE added by the isql extract.
Has anyone any idea why this has stopped working?
Regards
Ian A. Newby
Environment: Windows XP, Firebird 1.0rc2 Dialect 1
I have a udf written in c which is cross platfor
m (linux,windows). Its been working fine on both interbase 6,
firebird 0.94, 1.0RC2.
Now however, if i try and access one of the functions from isql I
get:
SQL> select string_to_blob('th') from rdb$database;
STRING_TO_BLOB
=================
Statement failed, SQLCODE = -804
Dynamic SQL Error
-SQL error code = -804
-SQLDA missing or incorrect version, or incorrect number/type of
variables
The definition returned by idql is:
SQL> show function string_to_blob;
Function STRING_TO_BLOB:
Function library is wmudflib
Entry point is fn_string_blob
Argument 1: CSTRING(32000) CHARACTER SET NONE
Returns BLOB
The only thing that has changed is the database has been recreated
by extracting the metadata (from idql) and recreating it from the
script.
The portion of the script is as follows:
DECLARE EXTERNAL FUNCTION STRING_TO_BLOB
CSTRING(32000) CHARACTER SET NONE, BLOB
RETURNS PARAMETER 2
ENTRY_POINT 'fn_string_blob' MODULE_NAME 'wmudflib';
The only difference from my original script to add the functions is
the CHARACTER SET NONE added by the isql extract.
Has anyone any idea why this has stopped working?
Regards
Ian A. Newby