MikeRam wrote:
> 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();
> 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();
You can not use parameters inside a '' argument like that.
Arne
|
