posted 17 years ago
Hi All,
I am getting the following Sql Error message... "Invalid argument: parameter index 1 is out of range"
My seq statement is like this: SELECT CODE, DESCRIPTION FROM SCHEMA.CTMTORG WHERE SUBLEVELFLAG=? and GEOCODE=?
and my DAO class has the following statement..like this :
SUBLEVELFLAG="N"
pStat = connection.prepareStatement(sql);
pStat.setString(SettingsConstants.ONE,SUBLEVELFLAG);
pStat.setString(SettingsConstants.TWO,geoCode.trim());
rSet = pStat.executeQuery();
while (rSet.next()) {...} rest of the code..
what may be the problem??
Thanks in advance.... :-)
Too many people in the world are looking for the right person, instead of being the right person.