OracleParameterCollection Class
Collects all parameters relevant to a
OracleCommand as well as their respective mappings to
System.Data.DataSet columns.
The following example adds instance of
OracleParameter to collection.
|
|---|
public void AddOracleParameters()
{
// Create oracleConnection and oracleCommand.
oracleCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo";
oracleCommand.Parameters.Add("DeptNo", OracleDbType.Integer).Value = 50;
oracleCommand.ExecuteNonQuery();
} |
|
|---|
Public Sub AddOracleParameters()
// Create oracleConnection and oracleCommand.
oracleCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo"
oracleCommand.Parameters.Add("DeptNo", OracleDbType.Integer).Value = 50
oracleCommand.ExecuteNonQuery()
End Sub 'AddOracleParameters |