Oracle Data Provider Enumerations

The following is a list of enumerations that Oracle Data Provider for .NET provides.

FailoverEvent Enumeration
FailoverReturnCode Enumeration
FailoverType Enumeration
OracleCollectionType Enumeration
OracleDbType Enumeration
OracleParameterStatus Enumeration
OracleXmlCommandType Enumeration

FailoverEvent Enumeration

FailoverEvent enumerated values are used to explicitly specify the state of the failover.

Table 4-128 lists all the FailoverEvent enumeration values with a description of each enumerated value.

Table 4-128 FailoverEvent Enumeration Values

Member Names	Description
`FailoverEvent.Begin`	Indicates that failover has detected a lost connection and that failover is starting.
`FailoverEvent.End`	Indicates successful completion of failover.
`FailoverEvent.Abort`	Indicates that failover was unsuccessful, and there is no option of retrying.
`FailoverEvent.Error`	Indicates that failover was unsuccessful, and it gives the application the opportunity to handle the error and retry failover. The application can retry failover by returning `FailoverReturnCode.Retry` for the event notification.
`FailoverEvent.Reauth`	Indicates that a user handle has been reauthenticated. This applies to the situation where a client has multiple user sessions on a single server connection. During the initial failover, only the active user session is failed over. Other sessions are failed over when the application tries to use them. This is the value passed to the callback during these subsequent failovers.

See Also:

FailoverReturnCode Enumeration

FailoverReturnCode enumerated values are passed back by the application to the ODP.NET provider to request a retry in case of a failover error or to continue in case of a successful failover.

Table 4-129 lists the FailoverReturnCode enumeration values with a description of each enumerated value.

Table 4-129 FailoverReturnCode Enumeration Values

Member Names	Description
`FailoverReturnCode.Retry`	Requests ODP.NET to retry failover in case `FailoverEvent.Error` is passed to the application
`FailoverReturnCode.Success`	Requests ODP.NET to proceed so that the application receive more notifications, if any

See Also:

FailoverType Enumeration

FailoverType enumerated values are used to indicate the type of failover event that was raised.

Table 4-130 lists all the FailoverType enumeration values with a description of each enumerated value.

Table 4-130 FailoverType Enumeration Values

Member Names	Description
`FailoverType.Session`	Indicates that the user has requested only session failover.
`FailoverType.Select`	Indicates that the user has requested select and session failover.

See Also:

OracleCollectionType Enumeration

OracleCollectionType enumerated values specify whether the OracleParameter object represents a collection, and if so, specifies the collection type.

Table 4-131 lists all the OracleCollectionType enumeration values with a description of each enumerated value.

Table 4-131 OracleCollectionType Enumeration Values

Member Name	Description
`None`	Is not a collection type
`PLSQLAssociativeArray`	Indicates that the collection type is a PL/SQL Associative Array (or PL/SQL Index-By Table)

See Also:

OracleDbType Enumeration

OracleDbType enumerated values are used to explicitly specify the OracleDbType of an OracleParameter.

Table 4-132 lists all the OracleDbType enumeration values with a description of each enumerated value.

Table 4-132 OracleDbType Enumeration Values

Member Name	Description
`BFile`	Oracle `BFILE` type
`Blob`	Oracle `BLOB` type
`Byte`	`byte` type
`Char`	Oracle `CHAR` type
`Clob`	Oracle `CLOB` type
`Date`	Oracle `DATE` type
`Decimal`	Oracle `NUMBER` type
`Double`	8-byte `FLOAT` type
`Int16`	2-byte `INTEGER` type
`Int32`	4-byte `INTEGER` type
`Int64`	8-byte `INTEGER` type
`IntervalDS`	Oracle `INTERVAL DAY TO SECOND` type
`IntervalYM`	Oracle `INTERVAL YEAR TO MONTH` type
`Long`	Oracle `LONG` type
`LongRaw`	Oracle `LONG` `RAW` type
`NChar`	Oracle `NCHAR` type
`NClob`	Oracle `NCLOB` type
`NVarchar2`	Oracle `NVARCHAR2` type
`Raw`	Oracle `RAW` type
`RefCursor`	Oracle `REF` `CURSOR` type
`Single`	4-byte `FLOAT` type
`TimeStamp`	Oracle `TIMESTAMP` type
`TimeStampLTZ`	Oracle `TIMESTAMP WITH LOCAL TIME ZONE` type
`TimeStampTZ`	Oracle `TIMESTAMP WITH TIME ZONE` type
`Varchar2`	Oracle `VARCHAR2` type
`XmlType`	Oracle `XMLType` type

See Also:

OracleParameterStatus Enumeration

The OracleParameterStatus enumeration type indicates whether a NULL value is fetched from a column, whether truncation has occurred during the fetch, or whether a NULL value is to be inserted into a database column.

Table 4-133 lists all the OracleParameterStatus enumeration values with a description of each enumerated value.

Table 4-133 OracleParameterStatus Members

Member Name	Description
`Success`	Indicates that (for input parameters) the input value has been assigned to the column. For output parameter, it indicates that the provider assigned an intact value to the parameter.
`NullFetched`	Indicates that a `NULL` value has been fetched from a column or an `OUT` parameter
`NullInsert`	Indicates that a `NULL` value is to be inserted into a column
`Truncation`	Indicates that truncation has occurred when fetching the data from the column

See Also:

OracleXmlCommandType Enumeration

The OracleXmlCommandType enumeration specifies the values that are allowed for the XmlCommandType property of the OracleCommand class. It is used to specify the type of XML operation.

Table 4-134 lists all the OracleXmlCommandType enumeration values with a description of each enumerated value.

Table 4-134 OracleXmlCommandType Members

Member Name	Description
`None`	No XML operation is desired
`Query`	The command text is a SQL query and the result of the query is an XML document. The SQL query needs to be a select statement
`Insert`	The command text is an XML document containing rows to insert.
`Update`	The command text is an XML document containing rows to update.
`Delete`	The command text is an XML document containing rows to delete.

See Also: