ORA-01036: illegal variable name/number

[DotNetJunkies User]

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, escription, :LifeTime, riamryLife, :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;
}

}

 

[feng]

Maybe the OracleType is wrong.
Try one by one check.

ex:
string sql = "INSERT INTO EquipmentGroup (Code) VALUES Code)";

then check

string sql = "INSERT INTO EquipmentGroup (Code,Description) VALUES
Code,escription)";
....

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, escription, :LifeTime, riamryLife, :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,"Descrip
tion");
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;
}

}

engine supports Post Alerts, Ratings, and Searching.