dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleParameterCollection Class / Add Method / Add(String,OracleDbType,Int32,ParameterDirection,Boolean,Byte,Byte,String,DataRowVersion,Boolean,Object,Int32,String) Method
The name of the parameter.
One of the OracleDbType values.
The maximum size, in bytes, of the data the parameter can contain.
Specifies whether the parameter is input, output, both, or it is the return value.
Specifies whether the parameter is nullable
The maximum number of digits used to represent the parameter value.
The number of decimal places to which the parameter value is resolved.
The name of the source column.
One of the System.Data.DataRowVersion values.
Specifies whether the source column is nullable.
The Devart.Common.DbParameterBase.Value of the OracleParameter to add to the collection.
A length of the DML array or PL/SQL table.
The name of the object type that is the type of the parameter.

In This Topic
    Add(String,OracleDbType,Int32,ParameterDirection,Boolean,Byte,Byte,String,DataRowVersion,Boolean,Object,Int32,String) Method
    In This Topic
    Adds the specified OracleParameter to the OracleParameterCollection.
    Syntax
    'Declaration
     
    Public Overloads Function Add( _
       ByVal parameterName As String, _
       ByVal dbType As OracleDbType, _
       ByVal size As Integer, _
       ByVal direction As ParameterDirection, _
       ByVal isNullable As Boolean, _
       ByVal precision As Byte, _
       ByVal scale As Byte, _
       ByVal sourceColumn As String, _
       ByVal sourceVersion As DataRowVersion, _
       ByVal sourceColumnNullMapping As Boolean, _
       ByVal value As Object, _
       ByVal arrayLength As Integer, _
       ByVal objectTypeName As String _
    ) As OracleParameter

    Parameters

    parameterName
    The name of the parameter.
    dbType
    One of the OracleDbType values.
    size
    The maximum size, in bytes, of the data the parameter can contain.
    direction
    Specifies whether the parameter is input, output, both, or it is the return value.
    isNullable
    Specifies whether the parameter is nullable
    precision
    The maximum number of digits used to represent the parameter value.
    scale
    The number of decimal places to which the parameter value is resolved.
    sourceColumn
    The name of the source column.
    sourceVersion
    One of the System.Data.DataRowVersion values.
    sourceColumnNullMapping
    Specifies whether the source column is nullable.
    value
    The Devart.Common.DbParameterBase.Value of the OracleParameter to add to the collection.
    arrayLength
    A length of the DML array or PL/SQL table.
    objectTypeName
    The name of the object type that is the type of the parameter.

    Return Value

    The new OracleParameter object.
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also