Oracle® Data Provider for .NET Developer's Guide 10g Release 1 (10.1) Part Number B10117-01 |
|
|
View PDF |
The following is a list of enumerations that Oracle Data Provider for .NET provides.
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. |
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 |
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. |
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) |
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: |
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 |
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. |