ORA-01008: not all variables bound

[Swetha S]

Hi,

Can you please tell where I am wrong, This is urgent.

String count = new String("select count (*) from Detail where" +" serviceCode = '" + service_code + "'" + " and " + " OFFERINGNO= '" + + "'");

try
{
stmnt = conn.prepareStatement("select count (*) from Detail where serviceCode = ? and OFFERINGNO = ? ");

stmnt.setLong(1, service_code);
resSet = stmnt.executeQuery();
while(resSet.next())
{
cont = resSet.getInt(1);
}
resSet.close(); // Release cursor
stmnt.close();

[Deepa More]

Swetha,
You have supplied only one argument to prepared statement but in query 2 arguments are required.

  serviceCode = ? and OFFERINGNO = ?  

serviceCode is set by

  stmnt.setLong(1, service_code);  

I thing you forgot to set

  OFFERINGNO = ?