Export (0) Print
Expand All

OracleParameter.Direction Property

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

Exception Type Condition
ArgumentException The property was not set to one of the valid ParameterDirection values.

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#, 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++] 
public:
void CreateOracleDbParameter() 
 {
    OracleParameter* myParameter = new OracleParameter();
    myParameter->ParameterName = S"pDName";
    myParameter->DbType = DbType::String;
    myParameter->Value = S"ENGINEERING";
    myParameter->SourceColumn = S"DName";
 }

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter 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: 

See Also

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

Show:
© 2014 Microsoft