OracleParameter Constructor(String,OracleDbType,String)

In This Topic

Syntax
Example
Requirements
See Also

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

Syntax

Visual Basic
C#

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

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

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleParameter Class
OracleParameter Members
Overload List

Send Feedback