--- In firebird-support@yahoogroups.com, "Panos Bairaktaris"
<panoramix95@...> wrote:

>
> Hi,
> I've installed these UDF funcitons from

http://perso.orange.fr/Udf4ORA/ in Firebird 1.5.

>
> DECLARE EXTERNAL FUNCTION TO_CHAR
> CSTRING(255)
> RETURNS CSTRING(255)
> ENTRY_POINT 'fn_to_char' MODULE_NAME 'rfunc';
>
> DECLARE EXTERNAL FUNCTION TO_CHARD
> TIMESTAMP,
> CSTRING(255)
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'fn_to_chard' MODULE_NAME 'rfunc';
>
> I have a CREATE VIEW statement that uses somewhere the TO_CHARD, and

parses ok:

>
> ----> to_chard(prod.start_date, 'MM/DD/YY')
>
>
> -but when I execute the SELECT * FROM aView i get this message :
>
> Statement failed, SQLCODE = -171
> function TO_CHARD could not be matched
>
> The prod.start_date is of type TIMESTAMP .
> What am i doing wrong here? Is changing to Firebird 2.0 gonna help?
> Thanks.
>
> [Non-text portions of this message have been removed]
>

Hello,

It seems you don't use the correct number of parameters ...
could you check that your view doesn't include something like:
TO_CHARD(prod.start_date)
without any format specification

Regards
PAscal