oracle ORA-00911 问题 解决

 

书写sql语句

using (OracleConnection conn = new OracleConnection(OracleString)){conn.Open();var trans = conn.BeginTransaction();string strsql = "insert into MYJYYZJ_print(STORECODE,CLS,NUM,LINE,FILDATE,CONTENT,STAT,LSTUPDTIME) values(:STORECODE,:CLS,:NUM,:LINE,:FILDATE,:CONTENT,:STAT,:LSTUPDTIME);";try{for (int i = 0; i < contents.Count; i++){OracleCommand com = new OracleCommand();List<OracleParameter> pars = new List<OracleParameter>(){new OracleParameter("STORECODE",storeCode),new OracleParameter("CLS",title), //1new OracleParameter("NUM", printNum), //2new OracleParameter("LINE", i + 1), //3new OracleParameter("FILDATE", DateTime.Now), //4new OracleParameter("CONTENT",contents[i]), //5new OracleParameter("STAT",10), //6new OracleParameter("LSTUPDTIME", DateTime.Now) //7 };PrepareCommand(com, conn, trans, CommandType.Text, strsql, pars.ToArray());if (com.ExecuteNonQuery() <= 0)throw new TangJiuBusinessException("插入错误");com.Parameters.Clear();}trans.Commit();return true;

 

一直报异常 错误消息为ORA-00911 无效字符  然后搜索了好多 结果又说sql语句的末尾多了个分号(“;”)的原因 抱着试试的心态去掉 后 一切正常

奇怪  plsql中也不报错啊

折腾了一上午，无语！！

转载于:https://www.cnblogs.com/xingbo/p/4460073.html

总结

以上是生活随笔为你收集整理的oracle ORA-00911 问题 解决的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。