OracleCommand Class

Represents a SQL statement, PL/SQL statement, or stored procedure to execute against an Oracle database.

For a list of all members of this type, see OracleCommand members.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbCommand
            Devart.Common.DbCommandBase
               Devart.Data.Oracle.OracleCommand

Syntax

[Visual Basic]
Public Class OracleCommand 
   Inherits DbCommandBase
   Implements IComponent, IDbCommand, ICloneable, IDisposable

[C#]
public class OracleCommand : DbCommandBase, IComponent, IDbCommand, ICloneable, IDisposable

Remarks

The OracleCommand class provides the following methods for executing commands against the Oracle database:
Item Description
ExecuteReader Executes commands that return rows.
ExecutePageReader Returns a specific subset of rows when paging through the results of a query.
Devart.Common.DbCommandBase.ExecuteNonQuery Executes SQL commands such as INSERT, DELETE, UPDATE or PL/SQL block.
Devart.Common.DbCommandBase.ExecuteScalar Retrieves a single value (for example, an aggregate value) from a database.
ExecuteArray Executes SQL statement specified number of times.

Item	Description
ExecuteReader	Executes commands that return rows.
ExecutePageReader	Returns a specific subset of rows when paging through the results of a query.
Devart.Common.DbCommandBase.ExecuteNonQuery	Executes SQL commands such as INSERT, DELETE, UPDATE or PL/SQL block.
Devart.Common.DbCommandBase.ExecuteScalar	Retrieves a single value (for example, an aggregate value) from a database.
ExecuteArray	Executes SQL statement specified number of times.

If execution of the command results in a fatal OracleException, the OracleConnection may close. However, the user can reopen the connection and continue.

This class supports cross-form data binding with the InterForm Technology.

Example

The following example uses the ExecuteReader method of OracleCommand, along with OracleDataReader and OracleConnection, to select rows from a table.

[C#]

public void ReadMyData(string myConnString) 
{ 
  string mySelectQuery = "SELECT * FROM Test.Dept"; 
  OracleConnection myConnection = new OracleConnection(myConnString); 
  OracleCommand myCommand = new OracleCommand(mySelectQuery,myConnection); 
  myConnection.Open(); 
  OracleDataReader myReader = myCommand.ExecuteReader(); 
  try 
  { 
    while (myReader.Read()) 
    { 
      Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1)); 
    } 
  } 
  finally 
  { 
  // always call Close when done reading. 
  myReader.Close(); 
  // always call Close when done reading. 
  myConnection.Close(); 
  } 
}

[Visual Basic]

Public Sub ReadMyData(myConnString As String)
   Dim mySelectQuery As String = "SELECT * FROM Test.Dept"
   Dim myConnection As New OracleConnection(myConnString)
   Dim myCommand As New OracleCommand(mySelectQuery, myConnection)
   myConnection.Open()
   Dim myReader As OracleDataReader = myCommand.ExecuteReader()
   Try
     While myReader.Read()
       Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
         + myReader.GetString(1))
     End While
   Finally
       ' always call Close when done reading.
       myReader.Close()
       ' always call Close when done with connection.
       myConnection.Close()
   End Try
 End Sub

See Also

Language