OracleCommand Members

6.2.1 OracleCommand Members

OracleCommand members are listed in the following tables.

OracleCommand Constructors

OracleCommand constructors are listed in Table 6-8.

Table 6-8 OracleCommand Constructors

Constructor	Description
OracleCommand Constructors	Instantiates a new instance of `OracleCommand` class (Overloaded)

OracleCommand Static Methods

The OracleCommand static method is listed in Table 6-9.

Table 6-9 OracleCommand Static Method

Method	Description
`Equals`	Inherited from `System.Object` (Overloaded)

OracleCommand Properties

OracleCommand properties are listed in Table 6-10.

Table 6-10 OracleCommand Properties

Property	Description
AddRowid	Adds the `ROWID` as part of the select list
AddToStatementCache	Causes executed statements to be cached, when the property is set to `true` and statement caching is enabled
ArrayBindCount	Specifies if the array binding feature is to be used and also specifies the maximum number of array elements to be bound in the `Value` property
ArrayBindRowsAffected	Returns the number of affected rows for each iteration while executing a DML using array binding
BindByName	Specifies the binding method in the collection
CommandText	Specifies the SQL statement or stored procedure to run against the Oracle database or the XML data used to store changes to the Oracle database
CommandTimeout	Specifies the number of seconds the command is allowed to execute before terminating the execution with an exception
CommandType	Specifies the command type that indicates how the `CommandText` property is to be interpreted
Connection	Specifies the `OracleConnection` object that is used to identify the connection to execute a command
`Container`	Inherited from `System.ComponentModel.Component`
DesignTimeVisible	Specifies whether or not the `OracleCommand` object is visible on designer controls.
FetchSize	Specifies the size of `OracleDataReader`'s internal cache to store result set data
ImplicitRefCursors	Specifies an array of `OracleRefCursors` mapped to an implicit resultset returned by the stored procedure. Not Available in the ODP.NET, Managed Driver and ODP.NET Core
InitialLOBFetchSize	Specifies the amount of data that the `OracleDataReader` initially fetches for LOB columns
InitialLONGFetchSize	Specifies the amount of data that the `OracleDataReader` initially fetches for `LONG` and `LONG` `RAW` columns
Notification	Indicates that there is a notification request for the command
NotificationAutoEnlist	Indicates whether or not to register for a continuous query notification with the database automatically when the command is executed
Parameters	Specifies the parameters for the SQL statement or stored procedure
RowSize	Specifies the amount of memory needed by the `OracleDataReader` internal cache to store one row of data
Site	Inherited from `System.ComponentModel.Component`
Transaction	Specifies the `OracleTransaction` object in which the `OracleCommand` executes Not supported in a .NET stored procedure
UpdatedRowSource	Specifies how query command results are applied to the row being updated Not supported in a .NET stored procedure
UseEdmMapping	Indicates whether or not the command object utilizes the Entity Data Model mapping configuration values
XmlCommandType	Specifies the type of XML operation on the `OracleCommand`
XmlQueryProperties	Specifies the properties that are used when an XML document is created from the result set of a SQL query statement
XmlSaveProperties	Specifies the properties that are used when an XML document is used to save changes to the database

OracleCommand Public Methods

OracleCommand public methods are listed in Table 6-11.

Table 6-11 OracleCommand Public Methods

Public Method	Description
Cancel	Attempts to cancels a command that is currently executing on a particular connection
Clone	Creates a copy of `OracleCommand` object
`CreateObjRef`	Inherited from `System.MarshalByRefObject`
CreateParameter	Creates a new instance of `OracleParameter` class
Dispose	Releases any resources or memory allocated by the object
`Equals`	Inherited from `System.Object` (Overloaded)
ExecuteNonQuery	Executes a SQL statement or a command using the `XmlCommandType` and `CommandText` properties and returns the number of rows affected
ExecuteReader	Executes a command (Overloaded)
ExecuteScalar	Returns the first column of the first row in the result set returned by the query
ExecuteStream	Executes a command using the `XmlCommandType` and `CommandText` properties and returns the results in a new `Stream` object
ExecuteToStream	Executes a command using the `XmlCommandType` and `CommandText` properties and appends the results as an XML document to the existing `Stream`
ExecuteXmlReader	Executes a command using the `XmlCommandType` and `CommandText` properties and returns the result as an XML document in a .NET `XmlTextReader` object
`GetHashCode`	Inherited from `System.Object`
`GetLifetimeService`	Inherited from `System.MarshalByRefObject`
`GetType`	Inherited from `System.Object`
`InitializeLifetimeService`	Inherited from `System.MarshalByRefObject`
Prepare	This method is a no-op
`ToString`	Inherited from `System.Object`