OracleParameter Constructor(String,OracleDbType,String)

In This Topic

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";
}

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

Reference

OracleParameter Class
OracleParameter Members
Overload List

Send Feedback