Skip Headers

Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1)

Part Number B10117-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

Oracle Data Provider Enumerations

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


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.


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


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.


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)


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


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


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.