OracleCommand Properties

6.2.4 OracleCommand Properties

OracleCommand properties are listed in Table 6-13.

Table 6-13 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 that of data 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