Hi Helen, Thanks for answer.

I tried too but doesn't worked, see below:


[root@server UDF]# cat /opt/firebird/firebird.conf | grep UdfAcces
# UdfAccess may be None, Full or Restrict. If you choose
UdfAccess = /opt/firebird/UDF

[root@server ~]# ls -lih /opt/firebird/UDF -lia
705808 dr-xr-xr-x 2 firebird firebird 4,0K Jun 24 19:52 .
574112 dr-xr-xr-x 12 firebird firebird 4,0K Jun 25 21:54 ..
705810 -r-xr-xr-x 1 firebird firebird 18K Set 25 2007 fbudf.so
705809 -r-xr-xr-x 1 firebird firebird 13K Set 25 2007 ib_udf.so
706368 -r-xr-xr-x 1 firebird firebird 71K Jun 24 19:57 rfunc

SQL> show function lpad;
Function LPAD:
Function library is ib_udf
Entry point is IB_UDF_lpad
Returns FREE_IT CSTRING(255) CHARACTER SET ISO8859_1
Argument 1: NULL CSTRING(255) CHARACTER SET ISO8859_1
Argument 2: INTEGER
Argument 3: NULL CSTRING(1) CHARACTER SET ISO8859_1

SQL> select lpad( 'test', 10, '0') from rdb$database;
Statement failed, SQLCODE = -104
invalid request BLR at offset 63
-function LPAD is not defined
-module name or entrypoint could not be found