oracle怎么添加try catch,关于try-catch跟oracle事务

C# codeprotected void Button1_Click(object sender, EventArgs e)

{

try

{

//其他代码

OracleConnection conn = new OracleConnection(ConnectionString);

OracleTransaction transaction = null;

OracleCommand cmd = null;

try

{

conn.Open();

transaction = conn.BeginTransaction();//事务开始

cmd = conn.CreateCommand();

cmd.CommandText = "insert into table1 (name) values ('abc')";

cmd.Transaction = transaction;

cmd.ExecuteNonQuery();

transaction.Commit();//提交

Response.Redirect("index.aspx");

}

catch

{

transaction.Rollback();//回滚

}

finally

{

if (cmd != null) cmd.Dispose();

if (conn != null)

{

conn.Close();

conn.Dispose();

}

}

}

catch (Exception ex)

{

}

}