Re: [Firebird-test] UDFs in procedure

[Helen B. <he...@tp...>]

At 01:35 AM 11/11/2006, you wrote:
>Hello,
>how to call UDFs function in procedure ?
>
>For example, I would like to create an alias of the UDF ASCII_CHAR  :
>
>
>CREATE FUNCTION CHR(num NUMBER)
>  RETURN CHAR
>   IS chrRet CHAR(1);
>BEGIN
>  RETURN(ASCII_CHAR(num));
>END;
>
>This doesn't work....and I don't know why

Where on earth did you dig up this syntax?  It's not part of 
Firebird's SQL language.

If you want tech support, please don't use this list for it.  This is 
strictly for reporting field test problems and results.  Subscribe to 
the firebird-support list at 
http://www.yahoogroups.com/community/firebird-support.

fwiw, you don't "alias" external functions by recreating them.  You 
can use whatever name you like for a UDF when you declare it to your 
database, e.g.

DECLARE EXTERNAL FUNCTION CHR
         INTEGER
         RETURNS CSTRING(1) FREE_IT
         ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';

Helen
(list admin)