Subject Re: fbudf under linux
Author Fabrice Aeschbacher
Thomas,

My (linux) version of fb_udf does have an entry point called 'right'
(checked with nm). I tried to copy fb_util almost everywhere, but it
does not help.

I tried to install firebird 1.5 CS on another linux box, and I could
use fb_udf without any problem.

FB 1.5 comes with 2 udf libs: ib_udf.so and fb_udf.so

The first works great with FB1.0.3
The second (of course, containing the udf I need :-( does not.

Best regards,
Fabrice

--- In firebird-support@yahoogroups.com, "Thomas Beneken"
<beneken@r...> wrote:
> Hello Fabrice,
>
> I'm no Firebird expert and I'm running FB under Windows. But I had a
peek
> into the dependencies of fb_udf. It depends on fb_util for memory
> allocation. Most likely the same with Linux? So perhaps checkking access
> pathes or copying fb_util from /bin to /udf may help.
>
> Mhm... looking further: there is no entry point called right in my
version
> of fb_udf. Is IB_UDF_rtrim what You need?
>
> Best regards
> Thomas
>
> -----Original Message-----
> From: Fabrice Aeschbacher [mailto:fabrice.aeschbacher@s...]
> Sent: Tuesday, July 08, 2003 11:56 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: fbudf under linux
>
>
> Thanks Helen.
>
> I tried the 'fb_udf' syntax, and also with full path, but still got
> the error message. However, I am able to load other udfs from other
> libs which are in the same directory (/opt/interbase/UDF).
> Perhaps do I miss something to be able load the 1.5 udf from 1.0.3?
>
> Best regards,
> Fabrice
>
>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
> wrote:
> > At 09:24 AM 8/07/2003 +0000, you wrote:
> > >Thanks, Helen.
> > >
> > >I put a copy of fb_udf.so in the /opt/interbase/UDF directory of
my fb
> > >1.0.3. and then: #chown firebird:firebird fb_udf.so
> > >
> > >Then I executed the following command:
> > >
> > >--FBUDF_API paramdsc* right(paramdsc*, short* rl, paramdsc* rc)
> > >declare external function sright
> > >varchar(100) by descriptor, smallint,
> > >varchar(100) by descriptor returns parameter 3
> > >entry_point 'right' module_name 'fbudf';
> > >
> > >commit;
> > >
> > >But when executing:
> > >
> > >select sright('1234', 2) from rdb$database
> > >
> > >, I got the following error message:
> > >Invalid request BLR at offset 79
> > >Function SRIGHT is not defined
> > >module name or entrypoint could not be found.
> > >
> > >Do you have any idea of was is wrong?
> > >
> > >(I also tried declaring the udf with 'fb_udf.so',
> > >'/opt/interbase/UDF/fb_udf.so', and still got the same error)
> >
> > The declaration should be 'fb_udf' without the '.so' suffix -
different
> > from the declaration in the sql file (which is 'fbudf'). This is Very
> > Naughty of someone because it breaks cross-platform portablility.
> So I'm
> > posting a "gripe" to firebird-devel.
> >
> > heLen
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/