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