OracleParameter.Direction OracleParameter.Direction OracleParameter.Direction OracleParameter.Direction Property


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

 virtual property System::Data::ParameterDirection Direction { System::Data::ParameterDirection get(); void set(System::Data::ParameterDirection value); };
public override System.Data.ParameterDirection Direction { get; set; }
member this.Direction : System.Data.ParameterDirection with get, set
Public Overrides Property Direction As ParameterDirection

Property Value



The property was not set to one of the valid ParameterDirection values.


The following example creates a OracleParameter and sets some of its properties.

Public Sub CreateOracleDbParameter()  
   Dim parameter As New OracleParameter()  
   parameter.ParameterName = "pDName"  
   parameter.DbType = DbType.String  
   parameter.Value = "ENGINEERING"  
   parameter.SourceColumn = "DName"  
End Sub  
public void CreateOracleDbParameter()   
   OracleParameter parameter = new OracleParameter();  
   parameter.ParameterName = "pDName";  
   parameter.DbType = DbType.String;  
   parameter.Value = "ENGINEERING";  
   parameter.SourceColumn = "DName";  


If the ParameterDirection is output, and execution of the associated OracleCommand does not return a value, the OracleParameter contains a null value.

Output, InputOut, and ReturnValue parameters returned by calling ExecuteReader cannot be accessed until you call Close on the OracleDataReader.

Applies to