OracleCommand Public Methods
OracleCommand public methods are listed in Table 6-16.
Table 16 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 |
| ExecuteNonQueryAsync | Returns a Task-based asynchronous version of ExecuteNonQuery() (Overloaded). |
| ExecuteReader | Executes a command (Overloaded) |
| ExecuteReaderAsync | Returns a Task-based asynchronous version of OracleCommand.ExecuteReader(), which fetches the result set as an OracleDataReader object. (Overloaded) |
| ExecuteScalar | Returns the first column of the first row in the result set returned by the query |
| ExecuteScalarAsync | Returns a Task-based asynchronous version of OracleCommand.ExecuteScalar(), which returns the first column of the first row in the result set returned by the query. (Overloaded) |
| ExecuteStatements | Executes a stream of SQL and PL/SQL statements and returns any results as a JSON string |
| 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 |
| ExecuteXmlReaderAsync | Returns a Task-based asynchronous version of OracleCommand.ExecuteXmlReader(), which fetches the result set as an XmlReader object (Overloaded) |
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 |
| SetParametersForExecuteStatements | Binds a JSON stream of parameters for SQL script execution |
ToString |
Inherited from System.Object |