Hi
I m getting "java.sql.SQLException: ORA-01008: not all variables bound" exception while trying to execute an insert statement. Here is the code snippet
String query = "Insert into Query(Ques_id, Ques, Ans) values(SEQ_QUES_ID.NEXTVAL, ? , ? )";
stat =con.prepareStatement(query);
stat.setString(1,strQues);
stat.setString(2,strAns);
int rowsUpdated = stat.executeUpdate(query);
Here Ques and Ans are of type VARCHAR(150) in DB
I ve checked that there is no problem with the database connection.
thanks in advance