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

On this page

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 _ )

'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 )

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()); }

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

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

Reference

OracleParameter Class
OracleParameter Members
Overload List

Send Feedback