OracleParameter Constructor(String,OracleDbType,Int32,ParameterDirection,String,DataRowVersion,Boolean,Object)

In This Topic

Initializes a new instance of the OracleParameter class with the parameter name, data type, width, source column name, parameter direction, and other properties.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal parameterName As String, _
   ByVal dbType As OracleDbType, _
   ByVal size As Integer, _
   ByVal direction As ParameterDirection, _
   ByVal sourceColumn As String, _
   ByVal sourceVersion As DataRowVersion, _
   ByVal sourceColumnNullMapping As Boolean, _
   ByVal value As Object _
)

public OracleParameter( 
   string parameterName,
   OracleDbType dbType,
   int size,
   ParameterDirection direction,
   string sourceColumn,
   DataRowVersion sourceVersion,
   bool sourceColumnNullMapping,
   object value
)

Parameters

parameterName: The name of the parameter.
dbType: One of the OracleDbType values.
size: The maximum size, in bytes, of the data within the column.
direction: One of the System.Data.ParameterDirection values.
sourceColumn: The name of the source column.
sourceVersion: One of the System.Data.DataRowVersion values.
sourceColumnNullMapping: Specifies whether the source column is nullable.
value: An Object that is the value of the OracleParameter.

Example

The following example creates a new OracleParameter and sets some of its properties.

csharp

public void CreateOracleParameter()
{
        OracleParameter myParameter = new OracleParameter("DName", OracleDbType.VarChar, 
                15, ParameterDirection.Output, "DName", DataRowVersion.Current, true, "DEVELOPMENT");
        MessageBox.Show(myParameter.ToString());
}

Visual Basic

Public Sub CreateOracleParameter()
        Dim myParameter As New OracleParameter("DName", OracleDbType.VarChar, 15, _
                ParameterDirection.Output, "DName", DataRowVersion.Current, True, "DEVELOPMENT")
        MessageBox.Show(myParameter.ToString())
End Sub 'CreateOracleParameter

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

Reference

OracleParameter Class
OracleParameter Members
Overload List

Send Feedback