今天在公司忙了一天,老板说要满足客户的请求,让我改下程序。
本来一个很简单的问题,我搞了很久,仍然没有结果。
代码引用:
java.sql.SQLException: ORA-00911: 无效字符
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:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at com.csshd.news.bean.newsAdd.add(newsAdd.java:426)
at com.csshd.news.bean.newsAdd.main(newsAdd.java:1451)
下午,我找bug,都快疯掉了,我把sql语句放到pl/sql develper 里,竟然出错,最后才发现是逗号写错了,sql 语句里竟然有一个在中文输入下的逗号,郁闷!
insert into info_news
(unit_id,ngr_id,ngr,ngbm_id,ngbm,title,jjcd,
zycd,leixing,status,ng_date,cd_date,fj_name,fj_path,tp_name,
tp_path,qfr,leibei,QF_DATE)
values ('','','','','','','',
'','','','','','','','',
'','','','zzz')
你能看出这个语句错在哪里吗??