Subject Why this query doesn't work?
Author fabiano_bonin
FB 1.5.2

select
*
from
table1
where
udf_digits(table1.code) like udf_digits(:code)

An error was found in the application program input parameters for the
SQL statement.
Dynamic SQL Error.
SQL error code = -804.
Data type unknown.

The error happens in IBExpert and IBObjects also.

Here is the DDL of the udf:

DECLARE EXTERNAL FUNCTION UDF_DIGITS
CSTRING(254)
RETURNS CSTRING(254)
ENTRY_POINT 'udf_Digits' MODULE_NAME 'tbudf'

Regards,

Fabiano.