Subject | Prepared Statement and UDF |
---|---|
Author | itripn |
Post date | 2003-11-18T22:55:35Z |
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
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