There is a bug in the query and I already fixed it (one of the columns is listed twice in the select). However, SQLException is thrown when the first variable is being bound in the PreparedStatement. This suggests that the query actually being used by the
Java code is not the query listed in oracle.sql, because the query in oracle.sql has two bind variables in it as expected.
[originally posted on jforum.net by clc1023]