Subject Prepared Statement and UDF
Author itripn
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

Running the above command from isql like so:

SELECT name FROM foo WHERE varchar_like(name,'bar') = 1;

works fine.

Thoughts?
Thanks,
Ron