Export (0) Print
Expand All

OracleParameterCollection Class

Represents a collection of parameters relevant to an OracleCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.

System.Object
  System.MarshalByRefObject
    System.Data.Common.DbParameterCollection
      System.Data.OracleClient.OracleParameterCollection

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

[ListBindableAttribute(false)]
public sealed class OracleParameterCollection : DbParameterCollection

The OracleParameterCollection type exposes the following members.

  NameDescription
Public methodOracleParameterCollectionInitializes a new instance of the OracleParameterCollection class.
Top

  NameDescription
Public propertyCountReturns an Integer containing the number of elements in the OracleParameterCollection. Read-only. (Overrides DbParameterCollection.Count.)
Public propertyIsFixedSizeGets a value that indicates whether the OracleParameterCollection has a fixed size. (Overrides DbParameterCollection.IsFixedSize.)
Public propertyIsReadOnlyGets a value that indicates whether the OracleParameterCollection is read-only. (Overrides DbParameterCollection.IsReadOnly.)
Public propertyIsSynchronizedGets a value that indicates whether the OracleParameterCollection is synchronized. (Overrides DbParameterCollection.IsSynchronized.)
Public propertyItem[Int32]Gets or sets the OracleParameter at the specified index.
Public propertyItem[String]Gets or sets the OracleParameter with the specified name.
Public propertySyncRootGets an object that can be used to synchronize access to the OracleParameterCollection. (Overrides DbParameterCollection.SyncRoot.)
Top

  NameDescription
Public methodAdd(Object)Adds the specified OracleParameter object to the OracleParameterCollection. (Overrides DbParameterCollection.Add(Object).)
Public methodAdd(OracleParameter)Adds the specified OracleParameter to the OracleParameterCollection.
Public methodAdd(String, OracleType)Adds an OracleParameter to the OracleParameterCollection given the parameter name and data type.
Public methodAdd(String, Object) Obsolete. Adds an OracleParameter to the OracleParameterCollection given the parameter name and value.
Public methodAdd(String, OracleType, Int32)Adds an OracleParameter to the OracleParameterCollection given the parameter name, data type, and column length.
Public methodAdd(String, OracleType, Int32, String)Adds an OracleParameter to the OracleParameterCollection given the parameter name, data type, column length, and source column name.
Public methodAddRange(Array)Adds an array of values to the end of the OracleParameterCollection. (Overrides DbParameterCollection.AddRange(Array).)
Public methodAddRange(OracleParameter[])Adds an array of OracleParameter values to the end of the OracleParameterCollection.
Public methodAddWithValueAdds a value to the end of the OracleParameterCollection.
Public methodClearRemoves all of the OracleParameter objects from the OracleParameterCollection. (Overrides DbParameterCollection.Clear().)
Public methodContains(Object)Determines whether the specified object is in the OracleParameterCollection. (Overrides DbParameterCollection.Contains(Object).)
Public methodContains(OracleParameter)Determines whether the specified OracleParameter is in the OracleParameterCollection.
Public methodContains(String)Indicates whether an OracleParameter with the specified name is contained in the collection. (Overrides DbParameterCollection.Contains(String).)
Public methodCopyTo(Array, Int32)Copies all the elements of the current OracleParameterCollection to the specified one-dimensional Array starting at the specified destination Array index. (Overrides DbParameterCollection.CopyTo(Array, Int32).)
Public methodCopyTo(OracleParameter[], Int32)Copies all the elements of the current OracleParameterCollection to the specified OracleParameterCollection starting at the specified destination index.
Public methodCreateObjRefCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public methodEquals(Object)Determines whether the specified object is equal to the current object. (Inherited from Object.)
Public methodGetEnumeratorReturns an enumerator that iterates through the OracleParameterCollection. (Overrides DbParameterCollection.GetEnumerator().)
Public methodGetHashCodeServes as the default hash function. (Inherited from Object.)
Public methodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodIndexOf(Object)Gets the location of the specified Object within the collection. (Overrides DbParameterCollection.IndexOf(Object).)
Public methodIndexOf(OracleParameter)Gets the location of the specified OracleParameter within the collection.
Public methodIndexOf(String)Gets the location of the specified OracleParameter with the specified name. (Overrides DbParameterCollection.IndexOf(String).)
Public methodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public methodInsert(Int32, OracleParameter)Inserts a OracleParameter object into the OracleParameterCollection at the specified index.
Public methodInsert(Int32, Object)Inserts a Object into the OracleParameterCollection at the specified index. (Overrides DbParameterCollection.Insert(Int32, Object).)
Public methodRemove(Object)Removes the specified OracleParameter object from the collection. (Overrides DbParameterCollection.Remove(Object).)
Public methodRemove(OracleParameter)Removes the specified OracleParameter object from the collection.
Public methodRemoveAt(Int32)Removes the OracleParameter object at the specified index from the collection. (Overrides DbParameterCollection.RemoveAt(Int32).)
Public methodRemoveAt(String)Removes the OracleParameter object with the specified name from the collection. (Overrides DbParameterCollection.RemoveAt(String).)
Public methodToStringReturns a string that represents the current object. (Inherited from Object.)
Top

  NameDescription
Explicit interface implemetationPrivate propertyIDataParameterCollection.ItemGets or sets the parameter at the specified index. (Inherited from DbParameterCollection.)
Explicit interface implemetationPrivate propertyIList.ItemGets or sets the element at the specified index. (Inherited from DbParameterCollection.)
Top

When using named parameters, the number of parameters in the collection must be equal to the number of named parameters within the command text, or the .NET Framework Data Provider for Oracle raises an error.

The .NET Framework Data Provider for Oracle does not support the question mark (?) placeholder for passing parameters to an SQL statement called by an OracleCommand of CommandType.Text. In this case, named parameters must be used. For example:

SELECT * FROM Customers WHERE CustomerID = :pCustomerID

When using named parameters in an SQL statement called by an OracleCommand of CommandType.Text, you must precede the parameter name with a colon (:). However, in a stored procedure, or when referring to a named parameter elsewhere in your code (for example, when adding OracleParameter objects to the Parameters property), do not precede the named parameter with a colon (:). The data provider supplies the colon automatically.

The following example creates multiple instances of OracleParameter through the OracleParameterCollection within the OracleDataAdapter. These parameters are used to select data within the database and then place the data in the DataSet. This example assumes that a DataSet and an OracleDataAdapter have already been created with the appropriate schema, commands, and connection.

public void AddOracleParameters() 
 {
 // ... 
 // create dataSet and adapter 
 // ...
   adapter.SelectCommand.Parameters.Add("pEName", OracleType.VarChar, 80).Value = "Smith";
   adapter.SelectCommand.Parameters.Add("pEmpNo", OracleType.Int32).Value = 7369;
   adapter.Fill(dataSet);
 }

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0, 1.1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft