See Also

OracleCommand Class  | Devart.Data.Oracle Namespace  | OracleDataReader Class  | OracleConnection Class

See AlsoDevart.Data.OracleSend comments on this topic.

OracleCommand Class Members

Devart.Data.Oracle Namespace : OracleCommand Class

OracleCommand overview

Public Constructors

Public Constructor OracleCommand ConstructorOverloaded. Initializes a new instance of the OracleCommand class.

Public Properties

Public Property CachedGets or sets a value indicating whether Oracle resources assosiated with the current statement will be cached inside a session.
Public Property CommandTextOverridden. Gets or sets the SQL or PL/SQL statement or stored procedure to execute against the Oracle database.
Public Property CommandTimeoutOverridden. Gets or sets the wait time before terminating an attempt to execute a command and generating an error.
Public Property CommandTypeOverridden. Gets or sets a value indicating how the CommandText property is to be interpreted.
Public Property ConnectionGets or sets the OracleConnection used by this instance of the OracleCommand.
Public Property Container (Inherited from System.ComponentModel.Component)Gets the IContainer that contains the Component.
Public Property FetchSizeGets or sets the number of rows that will be transferred across the network at a time.
Public Property NotificationGets OracleNotificationRequest assigned by OracleDependency.
Public Property Owner (Inherited from Devart.Common.DbCommandBase)Gets or sets a form or other container that the Devart.Common.DbCommandBase instance belongs to.
Public Property ParameterCheck (Inherited from Devart.Common.DbCommandBase)Gets or sets a value indicating whether the command object regenerates parameter objects if text of the command is changed.
Public Property ParametersGets or sets the OracleParameterCollection.
Public Property PassParametersByNameGets or sets a value indicating whether stored procedure parameters are passed anonimously or with the names specified.
Public Property Site (Inherited from System.ComponentModel.Component)Gets or sets the ISite of the Component.
Public Property TableValuedResultType 
Public Property TransactionGets the OracleTransaction in which the OracleCommand executes.
Public Property UpdatedRowSource (Inherited from Devart.Common.DbCommandBase)Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter.

Public Methods

Public Method BeginExecuteNonQuery (Inherited from Devart.Common.DbCommandBase)Overloaded. Starts an asynchronous invocation of an Devart.Common.DbCommandBase.ExecuteNonQuery method.
Public Method BeginExecuteReader (Inherited from Devart.Common.DbCommandBase)Overloaded. Starts an asynchronous invocation of an ExecuteReader method.
Public Method CancelOverridden. Stops execution of OracleCommand methods.
Public Method CloneCreates a new object that is a copy of the current OracleCommand instance.
Public Method CreateObjRef (Inherited from System.MarshalByRefObject)Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Public Method CreateParameterCreates a new instance of a OracleParameter object.
Public Method Dispose (Inherited from System.ComponentModel.Component)Releases all resources used by the Component.
Public Method EndExecuteNonQuery (Inherited from Devart.Common.DbCommandBase)Ends an asynchronous invocation of the Devart.Common.DbCommandBase.ExecuteNonQuery method.
Public Method EndExecuteReaderEnds an asynchronous invocation of the ExecuteReader method.
Public Method ExecuteArrayExecutes SQL statement specified number of times.
Public Method ExecuteCursorExecutes the CommandText and returns an OracleCursor object.
Public Method ExecuteNonQueryOverridden. Executes SQL statement against the OracleConnection and returns the number of rows affected.
Public Method ExecutePageReaderReturns a specific subset of rows when paging through the results of a query.
Public Method ExecuteReaderOverloaded. Sends the CommandText to the Connection and builds a OracleDataReader.
Public Method ExecuteScalar (Inherited from Devart.Common.DbCommandBase)Executes 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.
Public Method GetLifetimeService (Inherited from System.MarshalByRefObject)Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Public Method GetRecordCount (Inherited from Devart.Common.DbCommandBase)Returns count of records in the resultset.
Public Method GetRowIdReturns Oracle ROWID string that represents physical location of the row inside the table.
Public Method InitializeLifetimeService (Inherited from System.MarshalByRefObject)Obtains a lifetime service object to control the lifetime policy for this instance.
Public Method Prepare (Inherited from Devart.Common.DbCommandBase)Creates a prepared (or compiled) version of the command on the server.
Public Method ResetCommandTimeoutOverridden. Resets CommandTimeout to its default value.
Public Method ToString (Inherited from System.ComponentModel.Component)Returns a String containing the name of the Component, if any. This method should not be overridden.

Public Events

Public Event Disposed (Inherited from System.ComponentModel.Component)Occurs when the component is disposed by a call to the Dispose method.

See Also

OracleCommand Class  | Devart.Data.Oracle Namespace  | OracleDataReader Class  | OracleConnection Class

 

 


© 2002 - 2013 Devart. All Rights Reserved.