At 02:00 AM 23/03/2006, you wrote:

>My problem is:
>I have an UDF function in my Linux Firebird Server that calls an
>external program (a perl script actually). That script connects to
>another FDB Server. The problem is that whenever I execute that
>function, my Linux FDB hangs and doesn't run the script.
>I tried running the script under "firebird" user, and it runs OK.
>If I avoid the connecting-to-another-FDB part in the script, it runs
>OK from within the Linux Firebird Server.

UDFs are external functions. They are not meant to perform any
database operations. They are meant to take [optional] input[s],
process it and return a result.

If you want to get a value from another database, use a
cross-database transaction and acquire the value using SQL. If that
involves a call to an external function then declare the function in
the other database and call it in your select expression on that
other database.

./heLen