--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> 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
>

Thanks Helen, you put me on the right track. I had to rename the .so
file from FreeAdhocUDF_fb2x.so to FreeAdhocUDF.so then DROP and
re-declare the function. I guess I'll have to do the same with the
other 404 functions...that should keep me busy for a while.

George