Question

.net连接oracle数据库是，所有变量都不为空，但出现错误ORA-01008: 并非所有变量都已绑定，怎么解决？

SqlHelper.ExecuteNonquery("insert into t_salary(id, empid, year, month, salary, boonel, publish) values(:id,:empid,:year,:month,:salary,:boonel,:publish)", new OleDbParameter(":id", es.Id), new OleDbParameter(":empid", es.EmpId), new OleDbParameter(":year", es.Year), new OleDbParameter(":month", es.Month), new OleDbParameter(":salary", es.Ssalary), new OleDbParameter(":boonel", es.Boonel), new OleDbParameter(":publish", es.Publish));

使用的是using System.Data.OleDb;

Answer 1

insert Ignore into t_salary 先用忽略报错的 再比较预想 和实际数据！