OracleParameter Constructor(String,OracleDbType,String)

On this page

Initializes a new instance of the OracleParameter class with the parameter name, data type.

Syntax

Visual Basic
C#


'Declaration Public Function New( _ ByVal parameterName As String, _ ByVal dbType As OracleDbType, _ ByVal objectTypeName As String _ )


public OracleParameter( string parameterName, OracleDbType dbType, string objectTypeName )

Parameters

parameterName: The name of the parameter.
dbType: One of the OracleDbType values.
objectTypeName: String representing a name for the Oracle object type.

Example

The following example creates a new OracleParameter of OracleObject type. For more detailed example of working with OracleObject type, refer to Objects article.

csharp


public void CreateOracleParameter() { OracleParameter myParameter = new OracleParameter("DName", OracleDbType.Object, "TPerson"); myParameter.Direction = ParameterDirection.Input; ((OracleObject)myParameter.Value)["ADDRESS"] = "69 Camden Road, London, NW1 9EU"; ((OracleObject)myParameter.Value)["Name"] = "Alex"; }

public void CreateOracleParameter()
{
        OracleParameter myParameter = new OracleParameter("DName", OracleDbType.Object, "TPerson");
        myParameter.Direction = ParameterDirection.Input;
        ((OracleObject)myParameter.Value)["ADDRESS"] = "69 Camden Road, London, NW1 9EU";
        ((OracleObject)myParameter.Value)["Name"] = "Alex";
}

Visual Basic


Public Sub CreateOracleParameter() Dim myParameter As New OracleParameter("DName", OracleDbType.Object, "TPerson") myParameter.Direction = ParameterDirection.Input CType(myParameter.Value, OracleObject)("ADDRESS") = "69 Camden Road, London, NW1 9EU" CType(myParameter.Value, OracleObject)("Name") = "Alex" End Sub 'CreateOracleParameter

Public Sub CreateOracleParameter()
        Dim myParameter As New OracleParameter("DName", OracleDbType.Object, "TPerson")
        myParameter.Direction = ParameterDirection.Input
        CType(myParameter.Value, OracleObject)("ADDRESS") = "69 Camden Road, London, NW1 9EU"
        CType(myParameter.Value, OracleObject)("Name") = "Alex"
End Sub 'CreateOracleParameter

Reference

OracleParameter Class
OracleParameter Members
Overload List

Send Feedback