| Class | Description | |
|---|---|---|
 | DirectUtils | Use this class to configure the packet size in the OracleConnection.Direct mode. |
| NativeOracleArray | Represents an Oracle collection (VARRAY). |
| NativeOracleObject | Represents a Oracle object of type defined by user. |
| NativeOracleObjectBase | Represents an object of any Oracle object type defined by the user (Object, VARRAY or Nested table). |
| NativeOracleTable | Represents Oracle Nested table type. |
| OracleAlert | Represents Oracle alert message. |
| OracleAlerter | Manages Oracle alerts. |
| OracleAlerterAlertEventArgs | Provides data for the OracleAlerter.Alert event of the OracleAlerter class. |
| OracleAlerterErrorEventArgs | Provides data for the OracleAlerter.Error event of the OracleAlerter class. |
| OracleAlerterFinishEventArgs | Provides data for the OracleAlerter.Stopped event of the OracleAlerter class. |
| OracleAnyData | Represents Oracle SYS.ANYDATA type. |
| OracleArray | Represents a client-side cached Oracle collection (VARRAY). |
| OracleArrayDataReader | Allows to read a forward-only stream of rows from an OracleArray or OracleTable. |
| OracleAttribute | Represents an attribute of the OracleObject type. |
| OracleAttributeCollection | Represents attributes of Oracle object type. |
| OracleBFile | Represents a managed OracleBFile object to work with the Oracle BFILE data type. |
| OracleClientFactory | Represents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle. |
| OracleCommand | Represents a SQL statement, PL/SQL statement, or stored procedure to execute against Oracle. |
| OracleCommandBuilder | Automatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the Oracle. |
| OracleConnection | Represents an open connection to Oracle. |
| OracleConnectionErrorEventArgs | Provides data for the OracleConnection.Error event of the OracleConnection class. |
| OracleConnectionStringBuilder | Generates automatically connection strings used to connect to Oracle. |
| OracleCredential | Represents a pair of user name and password, with a password stored in a more secure way than a usual System.String. |
| OracleCursor | Represents an Oracle REF CURSOR and value of cursor field. |
| OracleDataAdapter | Represents a set of data commands and a data source connection that are used to fill the System.Data.DataSet and update an Oracle data. |
| OracleDatabase | This class represents an Oracle Database instance and allows you to start and stop it. |
| OracleDataReader | Reads a forward-only stream of rows from Oracle. |
| OracleDataSet | Represents an in-memory cache of data with support for Oracle-specific features. |
| OracleDataSourceEnumerator | Provides a mechanism for enumerating all known Oracle servers (TNS aliases). |
| OracleDataTable | Represents a single object that provides all of the functionality needed to retrieve and manipulate data from an Oracle data source. |
| OracleDependency | Represents a dependency between an application and an Oracle database. |
| OracleError | Represents an Oracle error returned by the server. |
| OracleErrorCollection | Collects errors of an exception generated by dotConnect for Oracle. This class cannot be inherited. |
| OracleException | The exception that is generated when Oracle returns an error. |
| OracleFailoverEventsArgs | Provides data for the OracleConnection.Failover event of the OracleConnection class. |
| OracleGlobalization | Manages the Oracle globalization settings of the application, and local computer. Oracle globalization settings of the local computer are read-only. |
| OracleHAEventArgs | Provides data for the OracleConnection.HAEvent event of the OracleConnection class. |
| OracleHome | Represents an Oracle home. |
| OracleHomeCollection | Represents a list of available Oracle homes. |
| OracleInfoMessageEventArgs | Provides data for the OracleConnection.InfoMessage event. |
| OracleLoader | Serves to load external data into the Oracle database. |
| OracleLoaderColumn | Represents the attributes for column loading. |
| OracleLoaderColumnCollection | Represents a collection of columns relevant to a OracleLoader. |
| OracleLoaderErrorEventArgs | Provides data for the OracleLoader.Error event of the OracleLoader class. |
| OracleLoaderRowsCopiedEventArgs | Provides data for the OracleLoader.Error event of the OracleLoader class. |
| OracleLob | Represents LOB data type stored on an Oracle server. |
| OracleLogicalTransaction | This class allows you to find out whether the transaction, running during the last database outage, was successfully committed and completed and determine whether your application should commit, complete, or rollback the transaction in order to avoid logical corruption because of committing duplicate transactions. |
| OracleLogicalTransactionStatus | Indicates the logical status of the transaction. |
| OracleMetaDataCollectionNames | Enumerates collection names you can use for metadata retrieval purposes. |
| OracleMonitor | Monitors dynamic SQL execution in applications that use dotConnect for Oracle. |
| OracleNotificationEventArgs | Provides data for the OracleDependency.OnChange event. |
| OracleNotificationRequest | Represents a notification request to be subscribed in the database. |
| OracleNumberMapping | Represents a mapping between .NET and Oracle number types. |
| OracleNumberMappingCollection | Represents a collection of OracleNumberMapping objects. |
| OracleObject | Represents a client-side cached Oracle object of type defined by user. |
| OraclePackage | Provides access to packages stored in the Oracle database. |
| OracleParameter | Represents a parameter to a OracleCommand, and optionally, its mapping to System.Data.DataSet columns. |
| OracleParameterCollection | Collects all parameters relevant to a OracleCommand as well as their respective mappings to System.Data.DataSet columns. |
| OraclePermission | Enables dotConnect for Oracle to ensure that a user has an adequate security level to access an Oracle database. This class cannot be inherited. |
| OraclePermissionAttribute | Associates a security action with a custom security attribute. |
| OraclePipe | Represents Oracle pipe. |
| OraclePipeMessage | Represents elementary piece of data to transfer through Oracle pipe. |
| OraclePipeMessageCollection | Represents data transferred through Oracle pipe. |
| OracleProviderException | The exception that is thrown when dotConnect for Oracle returns a provider (non-database) error. |
| OracleProviderFactory | Represents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle. |
| OracleQueue | Represents Oracle Streams Advanced Queuing (AQ). |
| OracleQueueAdmin | Manages Oracle Streams Advanced Queuing (AQ) configuration and administration information. |
| OracleQueueAgent | Identifies a producer or a consumer of a message. |
| OracleQueueAgentCollection | Represents a collection of OracleQueueAgent objects. |
| OracleQueueDequeueOptions | Represents the options available for the dequeue operation. |
| OracleQueueEnqueueOptions | Represents the options available for the enqueue operation. |
| OracleQueueMessage | Represents queue messages. |
| OracleQueueMessageEventArgs | Provides data for the OracleQueue.OnMessage event of the OracleQueue class. |
| OracleQueueMessageProperties | Describes the information that AQ uses to manage individual messages. |
| OracleQueueOptions | Queue options that are used upon creation. |
| OracleQueueTable | Represent queue table for messages of a predefined type. |
| OracleQueueTableOptions | Queue table properties, that are used for its creation. |
| OracleRef | Represents a reference to the object (REF). |
| OracleRowUpdatedEventArgs | Provides data for the OracleDataAdapter.RowUpdated event. |
| OracleRowUpdatingEventArgs | Provides data for the OracleDataAdapter.RowUpdating event. This class cannot be inherited. |
| OracleScript | Serves to execute series of SQL statements separated by special symbols, like SQL*Plus scripts. |
| OracleSelectStatement | Represents a SELECT statement. |
| OracleShardingKey | Represents sharding key value to set for a connecion in order to perform single-shard queries. |
| OracleSqlStatement | Represents a SQL statement. |
| OracleSqlStatementCollection | Represents a list of OracleSqlStatement objects. |
| OracleTable | Represents a client-side cached Oracle Nested table type. |
| OracleTrace | Controls server side SQL and PL/SQL tracing. |
| OracleTransaction | Represents a SQL transaction to be made in the Oracle database. |
| OracleType | Represents any Oracle object type defined by the user such as OracleObject, OracleArray or OracleTable. |
| OracleXml | Represents an Oracle XMLType instance. |
| SqlStatementExecuteEventArgs | Provides data for the OracleScript.SqlStatementExecute event of the OracleScript class. |
| SshOptions | Represents information required to establish a SSH connection. |
| SslOptions | Represents information required to establish a SSL connection. |
Devart.Data.Oracle Namespace
In This Topic
Classes
Interfaces
| Interface | Description | |
|---|---|---|
 | ICustomOracleArray | Represents an Oracle ARRAY. |
| ICustomOracleObject | Represents an Oracle OBJECT. |
Structures
| Structure | Description | |
|---|---|---|
 | OracleBinary | Represents a variable-length binary data to be stored in or retrieved from a database. |
| OracleDate | Represents the Oracle DATE data type. |
| OracleIntervalDS | Represents the Oracle INTERVAL DAY TO SECOND data type. Each object of the OracleIntervalDS class stores a period of time in term of days, hours, minutes, seconds, and fractional seconds. |
| OracleIntervalYM | Represents the Oracle INTERVAL YEAR TO MONTH data type. Each object of the OracleIntervalYM class stores a period of time in years and months. |
| OracleNumber | Represents the Oracle NUMBER or any numeric type. |
| OracleQueueMessageId | Represents the system-generated identification of the message. |
| OracleString | Represents a variable-length stream of characters to be stored in or retrieved from the database. |
| OracleTimeStamp | Represents the Oracle TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE data types. |
Delegates
Enumerations
| Enumeration | Description | |
|---|---|---|
 | OracleConnectMode | Holds fields which allow to open a session with specified privileges. |
| OracleDbType | Specifies the data type of a field, property, OracleParameter or OracleAttribute. |
| OracleFailoverState | Represents Transparent Application Failover state. |
| OracleFailoverType | Represents Transparent Application Failover type. |
| OracleHAEventSource | Indicates the source of a HA event. |
| OracleHAEventStatus | Indicates the status of the HA event source. |
| OracleIdentityType | Specifies how Oracle identity column values are generated. |
| OracleLoaderDefaultExpressionBehavior | Determines how OracleLoader handles default expressions for columns that are not explicitly being loaded when using direct path API (in the OCI mode). |
| OracleLoaderOptions | Allows configuring behavior of the OracleLoader class. |
| OracleLobOpenMode | Specifies whether an OracleLob should be opened in read-only or read/write mode. |
| OracleNotificationGroupingType | Specifies how query result change notifications are sent when notification groupng is enabled. |
| OracleNotificationInfo | Specifies the operation, for which a notification is received from Oracle server. |
| OracleNotificationType | Specifies the type of notification received from Oracle server. |
| OracleNumberType | Enumerates main Oracle number types. |
| OracleObjectType | Describes Oracle object type for the OracleError class. Object type is a logical structure of data stored in a database. A brief definitions of corresponding Oracle structures are given below. |
| OraclePdbOpenMode | Specifies the open mode for starting a PDB Oracle instance with the OracleDatabase.Startup method of the OracleDatabase class (for Oracle 12c and higher). |
| OracleQueryBasedNotificationMode | Specifies the mode for query-based notifications. |
| OracleQueueCompatible | Specifies the lowest database version with which the queue is compatible. |
| OracleQueueDeliveryMode | Specifies whether the message is persistent or buffered. If buffered, it will be lost after the application's shutdown. Persistent messages are stored in the database table. |
| OracleQueueDequeueMode | Specifies how the messages will be dequeued. |
| OracleQueueMessageGrouping | Specifies the message grouping behaviour. |
| OracleQueueMessageState | Specifies the state of the message. |
| OracleQueueNavigation | Specifies which message will be dequeued next. |
| OracleQueuePrivilege | The privilege to enqueue or dequeue messages on the queue. |
| OracleQueueSequenceDeviation | Specifies whether the message being enqueued should be dequeued before other messages already in the queue. |
| OracleQueueSortOrder | Specifies which parameters are used to order messages in the queue. The order is ascending. |
| OracleQueueSystemPrivilege | The AQ administration privilige granted to or revoked from a user or role. |
| OracleQueueType | Specifies whether the queue is normal, service or nonpersistent with RAW message payload. |
| OracleQueueVisibility | Specifies the visibility options for an enqueue operation. |
| OracleServerType | Specifies whether the connection is established to an Oracle database or to TimesTen database. |
| OracleShutdownMode | Specifies the shutdown mode for the OracleDatabase.Shutdown method that shuts down an Oracle Database instance. |
| OracleStartupMode | Specifies the database startup mode. |
| PlSqlTraceMode | Defines the level of PL/SQL trace for the OracleTrace component. |
| ReadLobMode | Determines how LOB data is fetched and represented. |
| SecurityLevel | Determines the configuration of Oracle Advanced Security data encryption and data integrity for the Direct mode. |
| SqlPlusStatementType | Describes type of SQL*Plus command. Unless the corresponding SQL*Plus command name is explicitly specified, it coincides with the enumeration member's title. The functionality of corresponding commands in SQL*Plus is given below. |
| SqlTraceMode | Defines the level of SQL trace for the OracleTrace component. |
| SshAuthenticationType | Specifies a type of the SSH protocol authentication. |
| TraceState | Specifies type of the trace mode in the OracleTrace component. |
| WalletMethod | Determines the source where to get certificates for SSL connections in the Direct mode. |
See Also