dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace
See Also  Inheritance Hierarchy


ClassDirectUtils Use this class to configure the packet size in the OracleConnection.Direct mode.
ClassNativeOracleArray Represents an Oracle collection (VARRAY).
ClassNativeOracleObject Represents a Oracle object of type defined by user.
ClassNativeOracleObjectBase Represents an object of any Oracle object type defined by the user (Object, VARRAY or Nested table).
ClassNativeOracleTable Represents Oracle Nested table type.
ClassOracleAlert Represents Oracle alert message.
ClassOracleAlerter Manages Oracle alerts.
ClassOracleAlerterAlertEventArgs Provides data for the OracleAlerter.Alert event of the OracleAlerter class.
ClassOracleAlerterErrorEventArgs Provides data for the OracleAlerter.Error event of the OracleAlerter class.
ClassOracleAlerterFinishEventArgs Provides data for the OracleAlerter.Stopped event of the OracleAlerter class.
ClassOracleAnyData Represents Oracle SYS.ANYDATA type.
ClassOracleArray Represents a client-side cached Oracle collection (VARRAY).
ClassOracleArrayDataReader Allows to read a forward-only stream of rows from an OracleArray or OracleTable.
ClassOracleAttribute Represents an attribute of the OracleObject type.
ClassOracleAttributeCollection Represents attributes of Oracle object type.
ClassOracleBFile Represents a managed OracleBFile object to work with the Oracle BFILE data type.
ClassOracleClientFactory Represents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle.
ClassOracleCommand Represents a SQL statement, PL/SQL statement, or stored procedure to execute against Oracle.
ClassOracleCommandBuilder Automatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the Oracle.
ClassOracleConnection Represents an open connection to Oracle.
ClassOracleConnectionErrorEventArgs Provides data for the OracleConnection.Error event of the OracleConnection class.
ClassOracleConnectionStringBuilder Generates automatically connection strings used to connect to Oracle.
ClassOracleCredential Represents a pair of user name and password, with a password stored in a more secure way than a usual System.String.
ClassOracleCursor Represents an Oracle REF CURSOR and value of cursor field.
ClassOracleDataAdapter 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.
ClassOracleDatabase This class represents an Oracle Database instance and allows you to start and stop it.
ClassOracleDataReader Reads a forward-only stream of rows from Oracle.
ClassOracleDataSet Represents an in-memory cache of data with support for Oracle-specific features.
ClassOracleDataSourceEnumerator Provides a mechanism for enumerating all known Oracle servers (TNS aliases).
ClassOracleDataTable Represents a single object that provides all of the functionality needed to retrieve and manipulate data from an Oracle data source.
ClassOracleDependency Represents a dependency between an application and an Oracle database.
ClassOracleError Represents an Oracle error returned by the server.
ClassOracleErrorCollection Collects errors of an exception generated by dotConnect for Oracle. This class cannot be inherited.
ClassOracleException The exception that is generated when Oracle returns an error.
ClassOracleFailoverEventsArgs Provides data for the OracleConnection.Failover event of the OracleConnection class.
ClassOracleGlobalization Manages the Oracle globalization settings of the application, and local computer. Oracle globalization settings of the local computer are read-only.
ClassOracleHAEventArgs Provides data for the OracleConnection.HAEvent event of the OracleConnection class.
ClassOracleHome Represents an Oracle home.
ClassOracleHomeCollection Represents a list of available Oracle homes.
ClassOracleInfoMessageEventArgs Provides data for the OracleConnection.InfoMessage event.
ClassOracleLoader Serves to load external data into the Oracle database.
ClassOracleLoaderColumn Represents the attributes for column loading.
ClassOracleLoaderColumnCollection Represents a collection of columns relevant to a OracleLoader.
ClassOracleLoaderErrorEventArgs Provides data for the OracleLoader.Error event of the OracleLoader class.
ClassOracleLoaderRowsCopiedEventArgs Provides data for the OracleLoader.Error event of the OracleLoader class.
ClassOracleLob Represents LOB data type stored on an Oracle server.
ClassOracleLogicalTransaction 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.
ClassOracleLogicalTransactionStatus Indicates the logical status of the transaction.
ClassOracleMetaDataCollectionNames Enumerates collection names you can use for metadata retrieval purposes.
ClassOracleMonitor Monitors dynamic SQL execution in applications that use dotConnect for Oracle.
ClassOracleNotificationEventArgs Provides data for the OracleDependency.OnChange event.
ClassOracleNotificationRequest Represents a notification request to be subscribed in the database.
ClassOracleNumberMapping Represents a mapping between .NET and Oracle number types.
ClassOracleNumberMappingCollection Represents a collection of OracleNumberMapping objects.
ClassOracleObject Represents a client-side cached Oracle object of type defined by user.
ClassOraclePackage Provides access to packages stored in the Oracle database.
ClassOracleParameter Represents a parameter to a OracleCommand, and optionally, its mapping to System.Data.DataSet columns.
ClassOracleParameterCollection Collects all parameters relevant to a OracleCommand as well as their respective mappings to System.Data.DataSet columns.
ClassOraclePermission Enables dotConnect for Oracle to ensure that a user has an adequate security level to access an Oracle database. This class cannot be inherited.
ClassOraclePermissionAttribute Associates a security action with a custom security attribute.
ClassOraclePipe Represents Oracle pipe.
ClassOraclePipeMessage Represents elementary piece of data to transfer through Oracle pipe.
ClassOraclePipeMessageCollection Represents data transferred through Oracle pipe.
ClassOracleProviderException The exception that is thrown when dotConnect for Oracle returns a provider (non-database) error.
ClassOracleProviderFactory Represents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle.
ClassOracleQueue Represents Oracle Streams Advanced Queuing (AQ).
ClassOracleQueueAdmin Manages Oracle Streams Advanced Queuing (AQ) configuration and administration information.
ClassOracleQueueAgent Identifies a producer or a consumer of a message.
ClassOracleQueueAgentCollection Represents a collection of OracleQueueAgent objects.
ClassOracleQueueDequeueOptions Represents the options available for the dequeue operation.
ClassOracleQueueEnqueueOptions Represents the options available for the enqueue operation.
ClassOracleQueueMessage Represents queue messages.
ClassOracleQueueMessageEventArgs Provides data for the OracleQueue.OnMessage event of the OracleQueue class.
ClassOracleQueueMessageProperties Describes the information that AQ uses to manage individual messages.
ClassOracleQueueOptions Queue options that are used upon creation.
ClassOracleQueueTable Represent queue table for messages of a predefined type.
ClassOracleQueueTableOptions Queue table properties, that are used for its creation.
ClassOracleRef Represents a reference to the object (REF).
ClassOracleRowUpdatedEventArgs Provides data for the OracleDataAdapter.RowUpdated event.
ClassOracleRowUpdatingEventArgs Provides data for the OracleDataAdapter.RowUpdating event. This class cannot be inherited.
ClassOracleScript Serves to execute series of SQL statements separated by special symbols, like SQL*Plus scripts.
ClassOracleSelectStatement Represents a SELECT statement.
ClassOracleShardingKey Represents sharding key value to set for a connecion in order to perform single-shard queries.
ClassOracleSqlStatement Represents a SQL statement.
ClassOracleSqlStatementCollection Represents a list of OracleSqlStatement objects.
ClassOracleTable Represents a client-side cached Oracle Nested table type.
ClassOracleTrace Controls server side SQL and PL/SQL tracing.
ClassOracleTransaction Represents a SQL transaction to be made in the Oracle database.
ClassOracleType Represents any Oracle object type defined by the user such as OracleObject, OracleArray or OracleTable.
ClassOracleXml Represents an Oracle XMLType instance.
ClassSqlStatementExecuteEventArgs Provides data for the OracleScript.SqlStatementExecute event of the OracleScript class.
ClassSshOptions Represents information required to establish a SSH connection.
ClassSslOptions Represents information required to establish a SSL connection.


InterfaceICustomOracleArray Represents an Oracle ARRAY.
InterfaceICustomOracleObject Represents an Oracle OBJECT.


StructureOracleBinary Represents a variable-length binary data to be stored in or retrieved from a database.
StructureOracleDate Represents the Oracle DATE data type.
StructureOracleIntervalDS 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.
StructureOracleIntervalYM Represents the Oracle INTERVAL YEAR TO MONTH data type. Each object of the OracleIntervalYM class stores a period of time in years and months.
StructureOracleNumber Represents the Oracle NUMBER or any numeric type.
StructureOracleQueueMessageId Represents the system-generated identification of the message.
StructureOracleString Represents a variable-length stream of characters to be stored in or retrieved from the database.
StructureOracleTimeStamp Represents the Oracle TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE data types.


DelegateOnChangeEventHandler Represents the method that will handle the OracleDependency.OnChange event of an OracleDependency.
DelegateOracleAlerterAlertEventHandler Represents the method that will handle the OracleAlerter.Alert event of an OracleAlerter.
DelegateOracleAlerterErrorEventHandler Represents the method that will handle the OracleAlerter.Error event of an OracleAlerter.
DelegateOracleAlerterFinishEventHandler Represents the method that will handle the OracleAlerter.Stopped event of an OracleAlerter.
DelegateOracleConnectionErrorEventHandler Represents the method that will handle the OracleConnection.Error event of an OracleConnection.
DelegateOracleFailoverEventHandler Represents the method that will handle the OracleConnection.Failover event of an OracleConnection.
DelegateOracleHAEventHandler Represents the method that will handle the OracleConnection.HAEvent event of an OracleConnection.
DelegateOracleInfoMessageEventHandler Represents the method that will handle the OracleConnection.InfoMessage event of an OracleConnection.
DelegateOracleLoaderErrorEventHandler Represents the method that will handle the OracleLoader.Error event of an OracleLoader.
DelegateOracleLoaderRowsCopiedEventHandler Represents the method that will handle the OracleLoader.RowsCopied event of an OracleLoader.
DelegateOracleQueueMessageEventHandler Represents the method that will handle the OracleQueue.OnMessage event of an OracleQueue.
DelegateOracleRowUpdatedEventHandler Represents the method that will handle the OracleDataAdapter.RowUpdated event of an OracleDataAdapter.
DelegateOracleRowUpdatingEventHandler Represents the method that will handle the OracleDataAdapter.RowUpdating event of an OracleDataAdapter.
DelegateSqlStatementExecuteEventHandler Represents the method that will handle the OracleScript.SqlStatementExecute event of an OracleScript.


EnumerationOracleConnectMode Holds fields which allow to open a session with specified privileges.
EnumerationOracleDbType Specifies the data type of a field, property, Devart.Data.Oracle.OracleParameter or OracleAttribute.
EnumerationOracleFailoverState Represents Transparent Application Failover state.
EnumerationOracleFailoverType Represents Transparent Application Failover type.
EnumerationOracleHAEventSource Indicates the source of a HA event.
EnumerationOracleHAEventStatus Indicates the status of the HA event source.
EnumerationOracleIdentityType Specifies how Oracle identity column values are generated.
EnumerationOracleLoaderDefaultExpressionBehavior Determines how OracleLoader handles default expressions for columns that are not explicitly being loaded when using direct path API (in the OCI mode).
EnumerationOracleLoaderOptions Allows configuring behavior of the OracleLoader class.
EnumerationOracleLobOpenMode Specifies whether an OracleLob should be opened in read-only or read/write mode.
EnumerationOracleNotificationGroupingType Specifies how query result change notifications are sent when notification groupng is enabled.
EnumerationOracleNotificationInfo Specifies the operation, for which a notification is received from Oracle server.
EnumerationOracleNotificationType Specifies the type of notification received from Oracle server.
EnumerationOracleNumberType Enumerates main Oracle number types.
EnumerationOracleObjectType 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.
EnumerationOraclePdbOpenMode Specifies the open mode for starting a PDB Oracle instance with the OracleDatabase.Startup method of the OracleDatabase class (for Oracle 12c and higher).
EnumerationOracleQueryBasedNotificationMode Specifies the mode for query-based notifications.
EnumerationOracleQueueCompatible Specifies the lowest database version with which the queue is compatible.
EnumerationOracleQueueDeliveryMode 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.
EnumerationOracleQueueDequeueMode Specifies how the messages will be dequeued.
EnumerationOracleQueueMessageGrouping Specifies the message grouping behaviour.
EnumerationOracleQueueMessageState Specifies the state of the message.
EnumerationOracleQueueNavigation Specifies which message will be dequeued next.
EnumerationOracleQueuePrivilege The privilege to enqueue or dequeue messages on the queue.
EnumerationOracleQueueSequenceDeviation Specifies whether the message being enqueued should be dequeued before other messages already in the queue.
EnumerationOracleQueueSortOrder Specifies which parameters are used to order messages in the queue. The order is ascending.
EnumerationOracleQueueSystemPrivilege The AQ administration privilige granted to or revoked from a user or role.
EnumerationOracleQueueType Specifies whether the queue is normal, service or nonpersistent with RAW message payload.
EnumerationOracleQueueVisibility Specifies the visibility options for an enqueue operation.
EnumerationOracleServerType Specifies whether the connection is established to an Oracle database or to TimesTen database.
EnumerationOracleShutdownMode Specifies the shutdown mode for the OracleDatabase.Shutdown method that shuts down an Oracle Database instance.
EnumerationOracleStartupMode Specifies the database startup mode.
EnumerationPlSqlTraceMode Defines the level of PL/SQL trace for the OracleTrace component.
EnumerationReadLobMode Determines how LOB data is fetched and represented.
EnumerationSecurityLevel Determines the configuration of Oracle Advanced Security data encryption and data integrity for the Direct mode.
EnumerationSqlPlusStatementType 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.
EnumerationSqlTraceMode Defines the level of SQL trace for the OracleTrace component.
EnumerationSshAuthenticationType Specifies a type of the SSH protocol authentication.
EnumerationTraceState Specifies type of the trace mode in the OracleTrace component.
EnumerationWalletMethod Determines the source where to get certificates for SSL connections in the Direct mode.

See Also