OracleParameterCollection Class

Collects all parameters relevant to a OracleCommand as well as their respective mappings to DataSet columns.

For a list of all members of this type, see OracleParameterCollection members.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.Data.Common.DbParameterCollection
         Devart.Common.DbParameterBaseCollection
            Devart.Data.Oracle.OracleParameterCollection

Syntax

[Visual Basic]
Public Class OracleParameterCollection 
   Inherits DbParameterBaseCollection
   Implements ICollection, IEnumerable, IList, IDataParameterCollection

[C#]
public class OracleParameterCollection : DbParameterBaseCollection, ICollection, IEnumerable, IList, IDataParameterCollection

Remarks

The number of parameters in the collection must be equal to the number of parameter placeholders within the command text, or Oracle raises an error.

Example

The following example adds instance of OracleParameter to collection.

[C#]

public void AddOracleParameters() 
{ 
  // Create myConnection and myCommand. 
 
  myCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo"; 
  myCommand.Parameters.Add("DeptNo", OracleDbType.Integer).Value = 50; 
  myCommand.ExecuteNonQuery(); 
}

[Visual Basic]

Public Sub AddOracleParameters()
   // Create myConnection and myCommand.
 
  myCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo"
   myCommand.Parameters.Add("DeptNo", OracleDbType.Integer).Value = 50
   myCommand.ExecuteNonQuery()
 
End Sub 'AddOracleParameters

See Also

Language