ORA-01008: 并非所有变量都已关联(急……)
不知道错在哪里?请高手帮帮忙!谢了!
数据库表结构:
create table TblRPTFILE
(RPTFILENO number not null,
RPTSHOWNAME varchar2(100) not null,
RPTFILENAME varchar2(50) not null,
RPTFILEBEGINYEAR date not null,
RPTFILEENDYEAR date not null,
constraint TblRPTFILE_PK primary key (rptfileno));
代码:
string sqlStr = "insert into tblRPTFILE values(RPTFILESeq.nextval,:RPTShowName,:RPTFileName,:StartDate,:EndDate)";
OracleCommand cmd = DB.GetCommand(sqlStr);
cmd.Parameters.Add(":RPTShowName",OracleType.VarChar,100).Value=this.reportName;
cmd.Parameters.Add(":RPTFileName",OracleType.VarChar,50).Value=this.filePath;
cmd.Parameters.Add(":StartDate",OracleType.DateTime).Value=OracleDateTime.Parse(this.startDate.ToString());
cmd.Parameters.Add(":EndDate",OracleType.DateTime).Value=OracleDateTime.Parse(this.endDate.ToString());
try
{
cmd.Connection.Open();
cmd.ExecuteNonQuery(); //到这就出错了
cmd.Connection.Close();
}