调用oracle包问题
klmy 2006-07-31 07:15:08 private void Page_Load ( object sender , EventArgs e )
{
Oracle_Update(1,"xxxx",50);
}
private void Oracle_Update(int id,string Name,int Age)
{
try
{
string Select_Sql = "TestPackage1.UpdateRecords" ;
Comm = new OracleCommand ( Select_Sql , Conn ) ;
Comm.CommandType = CommandType.StoredProcedure ;
Comm.Parameters.Add ( new OracleParameter("id_in",OracleType.Number,3) );
Comm.Parameters["id_in"].Value = id;
Comm.Parameters["id_in"].Direction = ParameterDirection.Input;
Comm.Parameters.Add ( new OracleParameter("newName",OracleType.VarChar,10,"Name") ) ;
Comm.Parameters["newName"].Value = Name;
Comm.Parameters["newName"].Direction =ParameterDirection.Input;
Comm.Parameters.Add (new OracleParameter("newAge",OracleType.Number,3,"age") ) ;
Comm.Parameters["newAge"].Value = Age;
Comm.Parameters["NewAge"].Direction = ParameterDirection.Input;
OracleDataAdapter dda = new OracleDataAdapter ( ) ;
dda.UpdateCommand = Comm ;
}
catch ( Exception ex )
{
Response.Write ( ex.Message ) ;
}
finally
{
Conn.Close ( ) ;
}
}
可是数据库中记录没有更新,是什么原因啊