C# 调用oracle存储过程 表和输出值没有更改 但是系统没报错
存储过程: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("系统错误解冻失败");
}
} --------------------编程问答-------------------- 我顶- -
--------------------编程问答-------------------- 我顶顶顶 --------------------编程问答-------------------- 顶顶顶顶顶
补充:.NET技术 , C#