String insertTopic="INSERT INTO T_TOPIC VALUES (TOPICSEQ.NEXTVAL,'"+
topic+"',0,'unchecked'";
String insertItem="INSERT INTO T_ITEM VALUES (ITEMSEQ.NEXTVAL, '"+item+
"','"+picName+"','"+desc+"',null,null,null,'unchecked','"+
topicID+"','"+userID+"'";
stmt.executeUpdate(insertTopic); //where the error being thrown
stmt.executeUpdate(insertItem);
}
catch(SQLException e)
{
e.printStackTrace();
}
Error says ORA-00917: comma needed.
apparently this is the insertTopic string's problem , but I don't think I forget any comma in the string. Anybody who has a sharp eye can find it for me ,please?
Thanks a lot