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@...]
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/