操作Oracle数据库实现上传图片到Blob类型的字段出现的问题

王朝asp·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

通过使用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");

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航