Roman,

We are using 1.0. To your knowledge, is there any existing problem with
trying to use a UDF in a prepared statement like this? Is it a known
limitation of 1.0.3 or should we able to do this? Any other syntax we
could try besides an unprepared statement? I'm wondering if the unquoted
column parameter is the issue.

TIA,

R.

-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Wednesday, November 19, 2003 6:42 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Prepared Statement and UDF

> 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


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.