Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Gets or sets a value indicating whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.

[Visual Basic]
Public Overridable Property Direction As ParameterDirection  _
   Implements IDataParameter.Direction
[C#]
public virtual ParameterDirection Direction {get; set;}
[C++]
public: __property virtual ParameterDirection get_Direction();
public: __property virtual void set_Direction(ParameterDirection);
[JScript]
public function get Direction() : ParameterDirection;
public function set Direction(ParameterDirection);

Property Value

One of the System.Data.ParameterDirection values. The default is Input.

Implements

IDataParameter.Direction

Exceptions

Remarks

If the ParameterDirection is Output, and execution of the associated OracleCommand does not return a value, the OracleParameter will contain a null value. Null values are handled using the DBNull class. Output, InputOut, and ReturnValue parameters returned by calling System.OracleClient.OracleCommand.ExecuteReader cannot be accessed until you call System.OracleClient.OracleDataReader.Close or Dispose on the OracleDataReader.

Example

[Visual Basic, C#] The following example creates an OracleParameter and sets some of its properties.

[Visual Basic] 
Public Sub CreateOracleDbParameter()
    Dim myParameter As New OracleParameter()
    myParameter.ParameterName = "pDName"
    myParameter.DbType = DbType.String
    myParameter.Value = "ENGINEERING"
    myParameter.SourceColumn = "DName"
End Sub 'CreateOracleDbParameter


[C#] 
public void CreateOracleDbParameter() 
 {
    OracleParameter myParameter = new OracleParameter();
    myParameter.ParameterName = "pDName";
    myParameter.DbType = DbType.String;
    myParameter.Value = "ENGINEERING";
    myParameter.SourceColumn = "DName";
 }

[C++, JScript] No example is available for C++ or JScript. To view a Visual Basic or C# example, click the Language Filter button in the upper-left corner of the page.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

.NET Framework Security: 

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries From Partially Trusted Code

See Also

OracleParameter Class | OracleParameter Members | System.Data.OracleClient Namespace