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.prepareCall(q);
stm.setString(1, sd.StringDataOraInizio);
stm.setString(2, sd.StringDataOraFine);
stm.execute();

I use Apache Derby but,
When i execute the attached code i receive an exception java.sql.SQLException: No input parameters.

Parametric query are usable in stored procedure ?
as i see from ref guide:

Reply via email to