存储过程:
private void button5_Click(object sender, EventArgs e)
        {
            string connectionString;
            string queryString = "UnFreeze";C# 
            connectionString = @"Data Source=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )" +
 "(CONNECT_DATA=(SID=orcl)));User Id=system;Password=740104;";//这个也可以放到Web.Config中。
            OracleConnection myConnection = new OracleConnection(connectionString);
            OracleCommand cmd = new OracleCommand(queryString, myConnection);
            cmd.CommandType = CommandType.StoredProcedure;            cmd.Parameters.Add("v_student_id", value);            cmd.Parameters.Add("v_flag", "0");
            try
            {                myConnection.Open();                cmd.ExecuteNonQuery();
                    MessageBox.Show("此卡已经成功解冻");                myConnection.Close();            }            catch (OracleException ex)
            {                MessageBox.Show("系统错误解冻失败");            }
        }