I get the error "java.sql.SQLException: ORA-00917: missing comma" when i execute the below insert statement.
stat.executeQuery("insert into sla values('','"+project_id+"','0','18-APR-11','"+bn.getSelectedPG()+"','"+Process+"','"+tot_vol+"','"+DefectOntime+"','"+DefectOntim e+"','"+DefectFree_Failed+"','"+DefectFree_Failed+"','"+CurrentDate+"','"+userID+"','"+Cur rentDate+"','"+userID+"',''");
It execute fine when i execute it in DB. I checked the value of variables inside insert statement, nothing looks wrong... Kindly help.
:)
Thanks in Advance,
Deepakkumar.
04-20-2011, 03:21 AM
deepakkumard1
This issue is resolved. I missed the close parenthesis for the insert statement. The error "Missing Comma" diverted me.
