Subject Re: [firebird-support] Calling UDF
Author Helen Borrie
At 11:01 PM 11/10/2007, you wrote:
>I have installed the FreeAdhocUDF library (FB 2.0.1). In FlameRobin,
>all of the UDFs from this library are listed as part of my database. I
>am attempting to use the F_REPLACESTRING UDF in a stored procedure.
>The SP compiles fine, but when I try to COMMIT the stored procedure to
>the database, I get the following message:
>
>SQL Message : -104
>Invalid token
>
>Engine Code : 335544343
>Engine Message :
>invalid request BLR at offset 244
>function F_REPLACESTRING is not defined
>module name or entrypoint could not be found
>
>Is there something else I need to do before I can use this UDF?

Make sure that you use the name (identifier) to invoke the function,
not the entrypoint. And if the module_name in your declarations has
a file suffix (like .dll or .so) then remove it from the source, drop
the function and redeclare and commit it, otherwise the engine will
be looking for ".dll.dll" (or ".so.so") and won't find it.

./hb