dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class
Properties Methods Events

In This Topic
    OracleCommand Class Members
    In This Topic

    The following tables list the members exposed by OracleCommand.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the OracleCommand class.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets a value indicating whether Oracle resources assosiated with the current statement will be cached inside a session.  
    Public PropertyOverridden. Gets or sets the SQL or PL/SQL statement or stored procedure to execute against the Oracle database.  
    Public PropertyOverridden. Gets or sets the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.  
    Public PropertyOverridden. Gets or sets a value indicating how the CommandText property is to be interpreted.  
    Public PropertyGets or sets the OracleConnection used by this instance of the OracleCommand.  
    Public PropertyGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyGets or sets the number of rows that will be transferred across the network at a time.  
    Public PropertyDetermines whether to send an additional query to check whether there are implicit REF CURSOR parameters if CommandType is CommandType.StoredProcedure and OracleConnectionStringBuilder.DescribeStoredProcedure is true when executing the command.  
    Public PropertyGets or sets the number of bytes of LOB data to prefetch and cache when querying data containing LOB columns. Default value is 0, which means no data is prefetched.  
    Public PropertyDetermines whether a command is a table-valued stored function call.  
    Public PropertyGets OracleNotificationRequest assigned by OracleDependency.  
    Public PropertyGets or sets a form or other container that the Devart.Common.DbCommandBase instance belongs to. (Inherited from Devart.Common.DbCommandBase)
    Public PropertyGets or sets a value indicating whether the command object regenerates parameter objects if text of the command is changed. (Inherited from Devart.Common.DbCommandBase)
    Public PropertyGets or sets the OracleParameterCollection.  
    Public PropertyGets or sets a value indicating whether stored procedure parameters are passed anonimously or with the names specified.  
    Public PropertyGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyGets the OracleTransaction in which the OracleCommand executes.  
    Public PropertyGets or sets how command results are applied to the System.Data.DataRow when used by the System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) method of the System.Data.Common.DbDataAdapter. (Inherited from Devart.Common.DbCommandBase)
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded. Starts an asynchronous invocation of an ExecuteNonQuery method. (Inherited from Devart.Common.DbCommandBase)
    Public MethodOverloaded. Starts an asynchronous invocation of an System.Data.Common.DbCommand.ExecuteReader method. (Inherited from Devart.Common.DbCommandBase)
    Public MethodOverridden. Stops execution of OracleCommand methods.  
    Public MethodCreates a new object that is a copy of the current OracleCommand instance.  
    Public MethodCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
    Public MethodCreates a new instance of a OracleParameter object.  
    Public MethodReleases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public MethodEnds an asynchronous invocation of the ExecuteNonQuery method. (Inherited from Devart.Common.DbCommandBase)
    Public MethodEnds an asynchronous invocation of the ExecuteReader method.  
    Public MethodOverloaded. Executes SQL statement specified number of times.  
    Public MethodExecutes the CommandText and returns an OracleCursor object.  
    Public MethodOverridden. Executes SQL statement against the OracleConnection and returns the number of rows affected.  
    Public MethodReturns a specific subset of rows when paging through the results of a query.  
    Public MethodOverloaded. Sends the CommandText to the Connection and builds a OracleDataReader.  
    Public MethodExecutes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored. (Inherited from Devart.Common.DbCommandBase)
    Public MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodReturns count of records in the resultset. (Inherited from Devart.Common.DbCommandBase)
    Public MethodReturns Oracle ROWID string that represents physical location of the row inside the table.  
    Public MethodObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodCreates a prepared (or compiled) version of the command on the server. (Inherited from Devart.Common.DbCommandBase)
    Public Method (Inherited from Devart.Common.DbCommandBase)
    Public MethodOverridden. Resets CommandTimeout to its default value.  
    Public MethodReturns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component)
    Top
    Public Events
     NameDescription
    Public EventOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
    Top
    See Also