q="SELECT * FROM "+dbTable+" WHERE "+FieldName+" BETWEEN ? AND ? ORDER
BY ID";
q="CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY('"+q+"','"+OutFile+"', null, null,
null)";
stm=cn.conn.prepareStatement(q);
stm.setString(1, sd.StringDataOraInizio);
stm.setString(2, sd.StringDataOraFine);
stm.executeUpdate();
I use Apache Derby but,
When i execute the attached code i receive an exception
java.sql.SQLException: No input parameters.
The same query in other point of my program do not produce an exception.
Maybe i can't use system procedure with parameter ?
Thanks
|
