通过使用OleDb操作Oracle数据库,成功实现图片上传到Blob类型的字段,但有时会发生ORA-01036错误的问题,经查询是错误提示为illegal variable name/number,不知道有谁能详细解释illegal variable name/number的意思
Oracle Data Provider for .NET Hi I am using ODP.NET (Oracle Data Provider for .NET) in my asp.net application. I have a table in my oracle database called "equipmentgroup". When the page loads for the first time i retrieve all the records from the table to a dataset and save it to viewstate. Later on any addition or modification is done in the dataset only in disconnected mode. Finally,when user clicks update i call this function "update" which should do a batch update but instead it gives the following error :
"ORA-01036: illegal variable name/number "
private void update() { OracleParameter workParam;
OracleConnection cnn = new OracleConnection("Data Source=NEELESHR;User Id=tmse; Password=tmse;"); string sql = "INSERT INTO EquipmentGroup (Code, Description, LifeTime, PriamryLife, Grading, Inflator, ExtensionRate, MaintenanceFee) VALUES (:Code, :Description, :LifeTime, :PriamryLife, :Grading, :Inflator, :ExtensionRate, :MaintenanceFee)"; OracleCommand cmd = new OracleCommand(sql,cnn); cmd.CommandType = CommandType.Text;
OracleDataAdapter da = new OracleDataAdapter(); da.InsertCommand = cmd; workParam = da.InsertCommand.Parameters.Add("Code",OracleType.Char,10,"Code"); workParam.SourceVersion = DataRowVersion.Current;
workParam = da.InsertCommand.Parameters.Add("Description",OracleType.VarChar,50,"Description"); workParam.SourceVersion = DataRowVersion.Current;
workParam = da.InsertCommand.Parameters.Add("LifeTime",OracleType.Number); workParam.SourceColumn = "LifeTime"; workParam.SourceVersion = DataRowVersion.Current;
workParam = da.InsertCommand.Parameters.Add("PriamryLife",OracleType.Number); workParam.SourceColumn = "PriamryLife"; workParam.SourceVersion = DataRowVersion.Current;
workParam = da.InsertCommand.Parameters.Add("Grading",OracleType.Char,10,"Grading"); workParam.SourceVersion = DataRowVersion.Current;
workParam = da.InsertCommand.Parameters.Add("Inflator",OracleType.Number); workParam.SourceColumn = "Inflator"; workParam.SourceVersion = DataRowVersion.Current;
workParam = da.InsertCommand.Parameters.Add("ExtensionRate",OracleType.Number); workParam.SourceColumn = "ExtensionRate"; workParam.SourceVersion = DataRowVersion.Current;
workParam = da.InsertCommand.Parameters.Add("MaintenanceFee",OracleType.Number); workParam.SourceColumn = "MaintenanceFee"; workParam.SourceVersion = DataRowVersion.Current;
try { da.Update(ds,"EquipmentGroup"); } catch(Exception e) { Message.Text = e.Message; }
}
Hi,
I think that you should add parameters with ":" included, like: workParam = da.InsertCommand.Parameters.Add(":Code",OracleType.Char,10,"Code");
OleDb Data Provider for .NET
string sql = "INSERT INTO EquipmentGroup (Code, Description, LifeTime, PriamryLife, Grading, Inflator, ExtensionRate, MaintenanceFee) VALUES (?, ?, ?, ?, ?, ?, ?, ?, )";
Hi,
I think that you should add parameters with ":" included, like: workParam = da.InsertCommand.Parameters.Add(":Code",OracleType.Char,10,"Code");
[ORACLE]Oracle中Blob字段的写入处理(一) [ORACLE]如何通过struts以oci协议将文件上传到oracle数据库… [ORACLE]如何在oracle里面操作BLOB [ORACLE]下载Oracle数据库中的Blob二进制文件,实例! [ORACLE]oracle+jsp中blob类型存储大文本问题解决方法 [ORACLE]在Oracle中存取BLOB对象实现文件的上传和下载 [ORACLE]在Java中使用Oracle blob [ORACLE]c# ,在Oracle 中,对 blob 类型对象的操作 [ORACLE]关于Oracle9i中BLOB类型的操作 [ORACLE]servlet实现从oracle数据库的blob字段中读出文件并…
|