Re: [Firebird-test] UDFs in procedure

[Martijn T. <m.t...@up...>]

> 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

CREATE FUNCTION won't work cause Firebird is the only DBMS that
doesn't support Stored Functions ;-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com