关于“ORA-00917: 缺少逗号”错误

Question

表的设计结构如下：Name                Type                Nullable Default Comments 
------------------- ------------------- -------- ------- -------- 
ID                  VARCHAR2(255 CHAR)                            
ONDUTOR             VARCHAR2(20 CHAR)   Y                         
ONDUTOR_ID          VARCHAR2(20 CHAR)   Y                         
ONDUTY_DATE         VARCHAR2(20 CHAR)   Y                         
RESPONSIBLE_DEPT    VARCHAR2(500 CHAR)  Y                         
RESPONSIBLE_DEPT_ID VARCHAR2(60 CHAR)   Y                         
IS_SECURE_ISSUE     VARCHAR2(1 CHAR)    Y                         
ONDUTY_RECORD       VARCHAR2(4000 CHAR) Y                         
ISSUE_AND_REASON    VARCHAR2(4000 CHAR) Y                         
RESULT              VARCHAR2(4000 CHAR) Y                         
CHECKER             VARCHAR2(20 CHAR)   Y                         
CHECKER_ID          VARCHAR2(20 CHAR)   Y                         
CHECK_DATE          VARCHAR2(20 CHAR)   Y                         
COMPANY_ID          VARCHAR2(20 CHAR)   Y                         
CREATE_ID           VARCHAR2(20 CHAR)   Y  插入的sql语句如下：
insert into SECURE_ONDUTY (ID,ONDUTOR,ONDUTOR_ID,ONDUTY_DATE,RESPONSIBLE_DEPT,RESPONSIBLE_DEPT_ID,IS_SECURE_ISSUE,ISSUE_AND_REASON,RESULT,CHECKER,CHECKER_ID,CHECK_DATE,COMPANY_ID) VALUES('10020','dd安质科','jlazk','2008-08-19','安质部','109','Y','gklk'','kltuy','dddd,'jtazb','2008-08-19','0')报的错误如下：java.sql.SQLException: ORA-00917: 缺少逗号 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2149)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2032)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2894)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:942)
at DataTran.trans(DataTran.java:84)==================================
我实在想不出有什么错了，麻烦大家帮我看看

Answer 1

insert into SECURE_ONDUTY (ID,ONDUTOR,ONDUTOR_ID,ONDUTY_DATE,RESPONSIBLE_DEPT,RESPONSIBLE_DEPT_ID,IS_SECURE_ISSUE,ISSUE_AND_REASON,RESULT,CHECKER,CHECKER_ID,CHECK_DATE,COMPANY_ID) VALUES('10020','dd安质科','jlazk','2008-08-19','安质部','109','Y','gklk'','kltuy','dddd,'jtazb','2008-08-19','0') 多了个分号

Answer 2

呵呵，我首先请问一下你的数据插入中文是乱码？还有你用的是ORACLE数据库把，你ORACLE是装在什么系统下面？是LINUX还是WINDOWS？？你问得太笼统，我不好回答，我也碰到过一个类似的问题！但是是再 LINUX下，我想也差不多哦！

Answer 3

呵呵，就是这个问题了，谢谢各位了
因为我插入的数据是从另一个数据库读出来的，自己写的数据导入程序，看来有bug，遇到字段里有引号值时没有做判断。