--- In firebird-support@yahoogroups.com, "Marcos Lommez" <lommez@...>
wrote:

>
> Here is the DDL of the ROUND UDF
>
> DECLARE EXTERNAL FUNCTION ROUND
> DOUBLE PRECISION,
> INTEGER
> RETURNS DOUBLE PRECISION BY VALUE
> ENTRY_POINT 'fn_round' MODULE_NAME 'rfunc';
>
>
> i have removed the round function of my procedure and works fine.
> But what is wrong with that udf?

UDFs are not part of Firebird; they are third party added
functionality (hence the name user defined functions), so unless you
have access to the source code ....

It is part of a UDF library called rfunc.dll (which I have heard of
but never personally used). I will assume that it is threadsafe given
it is a third party UDF that seems widely used.

Back to the questions you didn't answer:

Have you made sure that VALOR_OUT is not null?
Have you configured the UDF path in Firebird.conf?
Have you restarted firebird since making any change to this path
Are you able to use it in a simple query such as select ROUND(1.5, 1)
from RDB$DATABASE; ?

More questions:
Does the user the Firebird is installed as have file system level
permissions to execute that dll?

Adam