Subject | UDF problems |
---|---|
Author | Sacajawea |
Post date | 2005-04-05T19:41:24Z |
I'm having problems running UDFs. I'm using the .Net embedded
version.
UDF path is mapped correctly via the config variables RootDirectory
and UdfAccess (left as the default). I know this is correct because
before mapping I'd get the error:
Access to UDF library \"ib_udf.DLL\" is denied by server administrator
Once the mapping was fixed I no longer got that error.
I make sure I run the following SQL statement:
DECLARE EXTERNAL FUNCTION strlen CSTRING(32767) RETURNS INTEGER BY
VALUE ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf';
Then I run this SQL query:
select strlen('abc') from dummy;
And get the error:
invalid request BLR at offset 60\nfunction STRLEN is not defined
I know the "DECLARE EXTERNAL..." statement worked because if it's not
run I get the error:
Dynamic SQL Error\nSQL error code = -804\nFunction unknown\nSTRLEN
So ... if someone might offer some help I sure would appreciate it.
This is pretty critical.
Thanks.
-Abe
version.
UDF path is mapped correctly via the config variables RootDirectory
and UdfAccess (left as the default). I know this is correct because
before mapping I'd get the error:
Access to UDF library \"ib_udf.DLL\" is denied by server administrator
Once the mapping was fixed I no longer got that error.
I make sure I run the following SQL statement:
DECLARE EXTERNAL FUNCTION strlen CSTRING(32767) RETURNS INTEGER BY
VALUE ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf';
Then I run this SQL query:
select strlen('abc') from dummy;
And get the error:
invalid request BLR at offset 60\nfunction STRLEN is not defined
I know the "DECLARE EXTERNAL..." statement worked because if it's not
run I get the error:
Dynamic SQL Error\nSQL error code = -804\nFunction unknown\nSTRLEN
So ... if someone might offer some help I sure would appreciate it.
This is pretty critical.
Thanks.
-Abe