Export (0) Print
Expand All

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

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

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

'Declaration
Public Sub New ( _
	name As String, _
	oracleType As OracleType, _
	size As Integer, _
	direction As ParameterDirection, _
	isNullable As Boolean, _
	precision As Byte, _
	scale As Byte, _
	srcColumn As String, _
	srcVersion As DataRowVersion, _
	value As Object _
)

Parameters

name
Type: System.String

The name of the parameter.

oracleType
Type: System.Data.OracleClient.OracleType

One of the OracleType values.

size
Type: System.Int32

The length of the parameter.

direction
Type: System.Data.ParameterDirection

One of the ParameterDirection values.

isNullable
Type: System.Boolean

true if the value of the field can be null, otherwise, false.

precision
Type: System.Byte

The total number of digits to the left and right of the decimal point to which Value is resolved.

scale
Type: System.Byte

The total number of decimal places to which Value is resolved.

srcColumn
Type: System.String

The name of the source column.

srcVersion
Type: System.Data.DataRowVersion

One of the DataRowVersion values.

value
Type: System.Object

An Object that is the value of the OracleParameter.

ExceptionCondition
ArgumentException

The value supplied in the oracleType parameter is an invalid back-end data type.

The following example creates an OracleParameter and displays the ParameterName.

Public Sub CreateOracleParameter()
    Dim parameter As New OracleParameter( _
        "DName", OracleType.VarChar, 11, _
        ParameterDirection.Output, True, 0, 0, _
        "DName", DataRowVersion.Current, "ENGINEERING")
    Console.WriteLine(parameter.ToString())
End Sub

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1
Show:
© 2015 Microsoft