Subject Re: [firebird-support] Re: fbudf under linux
Author Helen Borrie
At 09:24 AM 8/07/2003 +0000, you wrote:
>Thanks, Helen.
>I put a copy of in the /opt/interbase/UDF directory of my fb
>1.0.3. and then: #chown firebird:firebird
>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';
>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 '',
>'/opt/interbase/UDF/', 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.