dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class
Members Example

On this page
    OracleCommand Class
    On this page
    Represents a SQL statement, PL/SQL statement, or stored procedure to execute against Oracle.
    Syntax
    Remarks
    The OracleCommand class provides the following methods for executing commands against the Oracle database:
    Item Description
    ExecuteReader Executes commands that return rows.
    Devart.Common.DbCommandBase.ExecutePageReader Returns a specific subset of rows when paging through the results of a query.
    ExecuteNonQuery Executes SQL commands such as INSERT, DELETE, UPDATE or PL/SQL block.
    ExecuteScalar Retrieves a single value (for example, an aggregate value) from a data source.
    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.
    public void ReadMyData(string myConnString)
    {
      string mySelectQuery = "SELECT DeptNo, DName FROM Test.Dept";
      OracleConnection oracleConnection = new OracleConnection(myConnString);
      OracleCommand oracleCommand = new OracleCommand(mySelectQuery,oracleConnection);
      oracleConnection.Open();
      OracleDataReader oracleReader = oracleCommand.ExecuteReader();
      try
      {
        while (oracleReader.Read())
        {
          Console.WriteLine(oracleReader.GetInt32(0).ToString() + ", " + oracleReader.GetString(1));
        }
      }
      finally
      {
      // always call Close when done reading.
      oracleReader.Close();
      // always call Close when done reading.
      oracleConnection.Close();
      }
    }
    Public Sub ReadMyData(myConnString As String)
      Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Test.Dept"
      Dim oracleConnection As New OracleConnection(myConnString)
      Dim oracleCommand As New OracleCommand(mySelectQuery, oracleConnection)
      oracleConnection.Open()
      Dim oracleReader As OracleDataReader = oracleCommand.ExecuteReader()
      Try
        While oracleReader.Read()
          Console.WriteLine(oracleReader.GetInt32(0).ToString() + ", " _
            + oracleReader.GetString(1))
        End While
      Finally
          ' always call Close when done reading.
          oracleReader.Close()
          ' always call Close when done with connection.
          oracleConnection.Close()
      End Try
    End Sub
    Inheritance Hierarchy

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

    See Also