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

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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)

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.

Exception Condition
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
Available since 1.1
Return to top
Show: