> I am trying to get parameter substitution in a PreparedStatement where
> the parameter is an argument to a UDF function. Example:
>
> SELECT name FROM foo WHERE varchar_like(name,?) = 1;
>
> when I attempt to execute this, I get:
>
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. Dynami SQL Error
> SQL error code = -804
> Data type unknown

Do you use Firebird 1.0? If yes, can you try 1.5? If the problem
exists in 1.5 too, can you please create a standalone test case and
send it to me together with your UDF?

Best regards,
Roman Rokytskyy