MikeRam wrote:
> q="SELECT * FROM "+dbTable+" WHERE "+FieldName+" BETWEEN ? AND ? ORDER
> BY ID";
> q="CALL SYSCS_UTIL.SYSCS_EX****T_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
>
>
>
Even with this syntax i receive the same exception
stm=cn.conn.prepareCall(q);
stm.setString(1, sd.StringDataOraInizio);
stm.setString(2, sd.StringDataOraFine);
stm.execute();
Parametric query are usable in stored procedure
as i see from ref guide:
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?)");
cs.setString(1, "US");
cs.setString(2, "CUSTOMER");
cs.setShort(3, (short) 1);
cs.execute();
|
