Subject Re: [firebird-support] FreeUDFLib
Author Daniel Albuschat
On Tue, 22 Mar 2005 09:36:18 -0300, Jean Derrie Rigo
<rigo@...> wrote:
>
> Someone can help me with the FreeUDFLib, more exactly with the Blobs
> Functions... I need to extract the data from a Blob field to a varchar field
> and I'm trying to install this UDF's, but, it doesn´t work...
>
> I declare the functions with no problem, but when I try to use the functions
> they give me the following message:
>
> the sql statement: select f_blobaspchar(fieldBlod) from table1
>
> the error message: Error at line 1 - invalid request BLR at offset 63
> function F_BLOBASPCHAR is not defined
> module name or entrypoint could not be found
>
> Someone else used this function?
> I appreciate any help, tanks!!!

The functions are initialised on first use, so there won't be necessarily an
error message on declaration if the actual dll/shared object is not in place.
Make sure that the dll/shared object (.dll or .so file, for
win32/linux respectively)
are located in firebird's UDF directory and have sufficient permissions set for
the firebird's process user.

Bye,
Daniel

--
eat(this); // delicious suicide