db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MikeRam <ing.ramu...@tiscali.it>
Subject Why exception exporting parametric query result on Derby ?
Date Sun, 27 Apr 2008 17:30:06 GMT
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:
 

Mime
View raw message