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