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

In This Topic

Syntax
Example
See Also

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

Syntax

Visual Basic
C#

public OracleParameter( 
   string parameterName,
   OracleDbType dbType,
   int size,
   ParameterDirection direction,
   bool isNullable,
   byte precision,
   byte scale,
   string sourceColumn,
   DataRowVersion sourceVersion,
   bool sourceColumnNullMapping,
   object value,
   int arrayLength,
   string objectTypeName
)

'Declaration
 
Public Function New( _
   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 _
)

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.
isNullable: true if the value of the field can be null; otherwise, false.
precision: The total number of digits to the left and right of the decimal point to which Devart.Common.DbParameterBase.Value is resolved.
scale: The total number of decimal places to which Devart.Common.DbParameterBase.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: An Object that is the value of the OracleParameter.
arrayLength: A length of the DML array or PL/SQL table.
objectTypeName: String representing a name for the Oracle object type.

Example

The following example creates a new OracleParameter and displays the ParameterName.

csharp

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

Visual Basic

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

Reference

OracleParameter Class
OracleParameter Members
Overload List

Send Feedback