书写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 = ; i < contents.Count; i++)
{
OracleCommand com = new OracleCommand();
List<OracleParameter> pars = new List<OracleParameter>()
{ new OracleParameter("STORECODE",storeCode),
new OracleParameter("CLS",title), //
new OracleParameter("NUM", printNum), //
new OracleParameter("LINE", i + ), //
new OracleParameter("FILDATE", DateTime.Now), //
new OracleParameter("CONTENT",contents[i]), //
new OracleParameter("STAT",), //
new OracleParameter("LSTUPDTIME", DateTime.Now) //
};
PrepareCommand(com, conn, trans, CommandType.Text, strsql, pars.ToArray());
if (com.ExecuteNonQuery() <= )
throw new TangJiuBusinessException("插入错误");
com.Parameters.Clear();
}
trans.Commit();
return true;
一直报异常 错误消息为ORA-00911 无效字符 然后搜索了好多 结果又说sql语句的末尾多了个分号(“;”)的原因 抱着试试的心态去掉 后 一切正常
奇怪 plsql中也不报错啊
折腾了一上午,无语!!