Missing Comma Error

[deepakkumard1]

Hello,

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.

[deepakkumard1]

This issue is resolved. I missed the close parenthesis for the insert statement. The error "Missing Comma" diverted me.