OracleCommand Properties
OracleCommand properties are listed in Table 6-15.
Table 15 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 |
| FetchSqlId | Indicates whether or not to fetch the Not Available in ODP.NET, Unmanaged Driver |
| ImplicitRefCursors | Specifies an array of OracleRefCursors mapped to an implicit resultset returned by the stored procedure. |
| 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 |
| RowsToFetchPerRoundTrip | Specifies the total number of rows to retrieve per database round trip Not Available in ODP.NET, Unmanaged Driver |
| Site | Inherited from System.ComponentModel.Component |
| SqlId | Provides the SQL_ID corresponding to the last executed statement on the OracleCommand |
| Transaction | Specifies the Not Available in ODP.NET, Unmanaged Driver |
| UpdatedRowSource | Specifies how query command results are applied to the row being updated |
| 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 |