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