OracleParameter Class

Represents a parameter to a OracleCommand, and optionally, its mapping to DataSet columns.

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

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.Data.Common.DbParameter
         Devart.Common.DbParameterBase
            Devart.Data.Oracle.OracleParameter

Syntax

[Visual Basic]
Public Class OracleParameter 
   Inherits DbParameterBase
   Implements IDataParameter, IDbDataParameter, ICloneable

[C#]
public class OracleParameter : DbParameterBase, IDataParameter, IDbDataParameter, ICloneable

Remarks

Parameter names are not case-sensitive.

Refer to article Using Parameters in dotConnect for Oracle to obtain detailed information on the matter together with some advanced examples.

Example

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

[C#]

public void AddOracleParameters() 
{ 
  // ... 
  // create myDataSet and myDataAdapter 
  // ... 
  myDataAdapter.SelectCommand.Parameters.Add("DName", OracleDbType.VarChar, 15).Value = "DEVELOPMENT"; 
  myDataAdapter.SelectCommand.Parameters.Add("DeptNo", OracleDbType.Integer).Value = 50; 
  myDataAdapter.Fill(myDataSet); 
}

[Visual Basic]

Public Sub AddOracleParameters()
   ' ...
   ' create myDataSet and myDataAdapter
   ' ...
   myDataAdapter.SelectCommand.Parameters.Add("DName", OracleDbType.VarChar, 15).Value = "DEVELOPMENT"
   myDataAdapter.SelectCommand.Parameters.Add("DeptNo", OracleDbType.Integer).Value = 50
   myDataAdapter.Fill(myDataSet)
 End Sub

See Also

Language