OracleCommand - Dispose all Parameters?
885808Sep 1 2011 — edited Sep 8 2011Using ODP.NET, v2.0.50727.
Question about Oracle.DataAccess.Client.OracleCommand Dispose call: Do I need to call Dispose on EACH Parameter I add?
Here's my code that creates and uses it (ignore my not checking cmd for null):
Oracle.DataAccess.Client.OracleConnection dbConn = null;
Oracle.DataAccess.Client.OracleCommand cmd = null;
try
{
dbConn = new Oracle.DataAccess.Client.OracleConnection(Application.OraMainConnString);
dbConn.Open();
cmd = new Oracle.DataAccess.Client.OracleCommand("SPDELETEENGINERUN", dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(":ENGINELOGIDIN", Oracle.DataAccess.Client.OracleDbType.Int32, 10, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Default, enginelogid);
cmd.ExecuteNonQuery();
}
catch { ... }
finally
{
cmd.Parameters[":ENGINELOGIDIN"].Dispose(); -- DO I NEED THIS CALL???*
cmd.Dispose();
dbConn.Close();
dbConn.Dispose();
}