dotConnect for Oracle Documentation
Inheritance Hierarchy
In This Topic
    Devart.Data.Oracle Namespace
    In This Topic
    Classes
     ClassDescription
    ClassUse this class to configure the packet size in the OracleConnection.Direct mode.
    ClassRepresents an Oracle collection (VARRAY).
    ClassRepresents a Oracle object of type defined by user.
    ClassRepresents an object of any Oracle object type defined by the user (Object, VARRAY or Nested table).
    ClassRepresents Oracle Nested table type.
    ClassRepresents Oracle alert message.
    ClassManages Oracle alerts.
    ClassProvides data for the OracleAlerter.Alert event of the OracleAlerter class.
    ClassProvides data for the OracleAlerter.Error event of the OracleAlerter class.
    ClassProvides data for the OracleAlerter.Stopped event of the OracleAlerter class.
    ClassRepresents Oracle SYS.ANYDATA type.
    ClassRepresents a client-side cached Oracle collection (VARRAY).
    ClassAllows to read a forward-only stream of rows from an OracleArray or OracleTable.
    ClassRepresents an attribute of the OracleObject type.
    ClassRepresents attributes of Oracle object type.
    ClassRepresents a managed OracleBFile object to work with the Oracle BFILE data type.
    ClassRepresents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle.
    ClassRepresents a SQL statement, PL/SQL statement, or stored procedure to execute against Oracle.
    ClassAutomatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the Oracle.
    ClassRepresents an open connection to Oracle.
    ClassProvides data for the OracleConnection.Error event of the OracleConnection class.
    ClassGenerates automatically connection strings used to connect to Oracle.
    ClassRepresents a pair of user name and password, with a password stored in a more secure way than a usual System.String.
    ClassRepresents an Oracle REF CURSOR and value of cursor field.
    ClassRepresents a set of data commands and a data source connection that are used to fill the System.Data.DataSet and update an Oracle data.
    ClassThis class represents an Oracle Database instance and allows you to start and stop it.
    ClassReads a forward-only stream of rows from Oracle.
    ClassRepresents an in-memory cache of data with support for Oracle-specific features.
    ClassProvides a mechanism for enumerating all known Oracle servers (TNS aliases).
    ClassRepresents a single object that provides all of the functionality needed to retrieve and manipulate data from an Oracle data source.
    ClassRepresents a dependency between an application and an Oracle database.
    ClassRepresents an Oracle error returned by the server.
    ClassCollects errors of an exception generated by dotConnect for Oracle. This class cannot be inherited.
    ClassThe exception that is generated when Oracle returns an error.
    ClassProvides data for the OracleConnection.Failover event of the OracleConnection class.
    ClassManages the Oracle globalization settings of the application, and local computer. Oracle globalization settings of the local computer are read-only.
    ClassProvides data for the OracleConnection.HAEvent event of the OracleConnection class.
    ClassRepresents an Oracle home.
    ClassRepresents a list of available Oracle homes.
    ClassProvides data for the OracleConnection.InfoMessage event.
    ClassServes to load external data into the Oracle database.
    ClassRepresents the attributes for column loading.
    ClassRepresents a collection of columns relevant to a OracleLoader.
    ClassProvides data for the OracleLoader.Error event of the OracleLoader class.
    ClassProvides data for the OracleLoader.Error event of the OracleLoader class.
    ClassRepresents LOB data type stored on an Oracle server.
    ClassThis 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.
    ClassIndicates the logical status of the transaction.
    ClassEnumerates collection names you can use for metadata retrieval purposes.
    ClassMonitors dynamic SQL execution in applications that use dotConnect for Oracle.
    ClassProvides data for the OracleDependency.OnChange event.
    ClassRepresents a notification request to be subscribed in the database.
    ClassRepresents a mapping between .NET and Oracle number types.
    ClassRepresents a collection of OracleNumberMapping objects.
    ClassRepresents a client-side cached Oracle object of type defined by user.
    ClassProvides access to packages stored in the Oracle database.
    ClassRepresents a parameter to a OracleCommand, and optionally, its mapping to System.Data.DataSet columns.
    ClassCollects all parameters relevant to a OracleCommand as well as their respective mappings to System.Data.DataSet columns.
    ClassEnables dotConnect for Oracle to ensure that a user has an adequate security level to access an Oracle database. This class cannot be inherited.
    ClassAssociates a security action with a custom security attribute.
    ClassRepresents Oracle pipe.
    ClassRepresents elementary piece of data to transfer through Oracle pipe.
    ClassRepresents data transferred through Oracle pipe.
    ClassThe exception that is thrown when dotConnect for Oracle returns a provider (non-database) error.
    ClassRepresents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle.
    ClassRepresents Oracle Streams Advanced Queuing (AQ).
    ClassManages Oracle Streams Advanced Queuing (AQ) configuration and administration information.
    ClassIdentifies a producer or a consumer of a message.
    ClassRepresents a collection of OracleQueueAgent objects.
    ClassRepresents the options available for the dequeue operation.
    ClassRepresents the options available for the enqueue operation.
    ClassRepresents queue messages.
    ClassProvides data for the OracleQueue.OnMessage event of the OracleQueue class.
    ClassDescribes the information that AQ uses to manage individual messages.
    ClassQueue options that are used upon creation.
    ClassRepresent queue table for messages of a predefined type.
    ClassQueue table properties, that are used for its creation.
    ClassRepresents a reference to the object (REF).
    ClassProvides data for the OracleDataAdapter.RowUpdated event.
    ClassProvides data for the OracleDataAdapter.RowUpdating event. This class cannot be inherited.
    ClassServes to execute series of SQL statements separated by special symbols, like SQL*Plus scripts.
    ClassRepresents a SELECT statement.
    ClassRepresents sharding key value to set for a connecion in order to perform single-shard queries.
    ClassRepresents a SQL statement.
    ClassRepresents a list of OracleSqlStatement objects.
    ClassRepresents a client-side cached Oracle Nested table type.
    ClassControls server side SQL and PL/SQL tracing.
    ClassRepresents a SQL transaction to be made in the Oracle database.
    ClassRepresents any Oracle object type defined by the user such as OracleObject, OracleArray or OracleTable.
    ClassRepresents an Oracle XMLType instance.
    ClassProvides data for the OracleScript.SqlStatementExecute event of the OracleScript class.
    ClassRepresents information required to establish a SSH connection.
    ClassRepresents information required to establish a SSL connection.
    Interfaces
     InterfaceDescription
    InterfaceRepresents an Oracle ARRAY.
    InterfaceRepresents an Oracle OBJECT.
    Structures
     StructureDescription
    StructureRepresents a variable-length binary data to be stored in or retrieved from a database.
    StructureRepresents the Oracle DATE data type.
    StructureRepresents 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.
    StructureRepresents the Oracle INTERVAL YEAR TO MONTH data type. Each object of the OracleIntervalYM class stores a period of time in years and months.
    StructureRepresents the Oracle NUMBER or any numeric type.
    StructureRepresents the system-generated identification of the message.
    StructureRepresents a variable-length stream of characters to be stored in or retrieved from the database.
    StructureRepresents the Oracle TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE data types.
    Delegates
     DelegateDescription
    DelegateRepresents the method that will handle the OracleDependency.OnChange event of an OracleDependency.
    DelegateRepresents the method that will handle the OracleAlerter.Alert event of an OracleAlerter.
    DelegateRepresents the method that will handle the OracleAlerter.Error event of an OracleAlerter.
    DelegateRepresents the method that will handle the OracleAlerter.Stopped event of an OracleAlerter.
    DelegateRepresents the method that will handle the OracleConnection.Error event of an OracleConnection.
    DelegateRepresents the method that will handle the OracleConnection.Failover event of an OracleConnection.
    DelegateRepresents the method that will handle the OracleConnection.HAEvent event of an OracleConnection.
    DelegateRepresents the method that will handle the OracleConnection.InfoMessage event of an OracleConnection.
    DelegateRepresents the method that will handle the OracleLoader.Error event of an OracleLoader.
    DelegateRepresents the method that will handle the OracleLoader.RowsCopied event of an OracleLoader.
    DelegateRepresents the method that will handle the OracleQueue.OnMessage event of an OracleQueue.
    DelegateRepresents the method that will handle the OracleDataAdapter.RowUpdated event of an OracleDataAdapter.
    DelegateRepresents the method that will handle the OracleDataAdapter.RowUpdating event of an OracleDataAdapter.
    DelegateRepresents the method that will handle the OracleScript.SqlStatementExecute event of an OracleScript.
    Enumerations
     EnumerationDescription
    EnumerationHolds fields which allow to open a session with specified privileges.
    EnumerationSpecifies the data type of a field, property, OracleParameter or OracleAttribute.
    EnumerationRepresents Transparent Application Failover state.
    EnumerationRepresents Transparent Application Failover type.
    EnumerationIndicates the source of a HA event.
    EnumerationIndicates the status of the HA event source.
    EnumerationSpecifies how Oracle identity column values are generated.
    EnumerationDetermines how OracleLoader handles default expressions for columns that are not explicitly being loaded when using direct path API (in the OCI mode).
    EnumerationAllows configuring behavior of the OracleLoader class.
    EnumerationSpecifies whether an OracleLob should be opened in read-only or read/write mode.
    EnumerationSpecifies how query result change notifications are sent when notification groupng is enabled.
    EnumerationSpecifies the operation, for which a notification is received from Oracle server.
    EnumerationSpecifies the type of notification received from Oracle server.
    EnumerationEnumerates main Oracle number types.
    EnumerationDescribes 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.
    EnumerationSpecifies the open mode for starting a PDB Oracle instance with the OracleDatabase.Startup method of the OracleDatabase class (for Oracle 12c and higher).
    EnumerationSpecifies the mode for query-based notifications.
    EnumerationSpecifies the lowest database version with which the queue is compatible.
    EnumerationSpecifies 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.
    EnumerationSpecifies how the messages will be dequeued.
    EnumerationSpecifies the message grouping behaviour.
    EnumerationSpecifies the state of the message.
    EnumerationSpecifies which message will be dequeued next.
    EnumerationThe privilege to enqueue or dequeue messages on the queue.
    EnumerationSpecifies whether the message being enqueued should be dequeued before other messages already in the queue.
    EnumerationSpecifies which parameters are used to order messages in the queue. The order is ascending.
    EnumerationThe AQ administration privilige granted to or revoked from a user or role.
    EnumerationSpecifies whether the queue is normal, service or nonpersistent with RAW message payload.
    EnumerationSpecifies the visibility options for an enqueue operation.
    EnumerationSpecifies whether the connection is established to an Oracle database or to TimesTen database.
    EnumerationSpecifies the shutdown mode for the OracleDatabase.Shutdown method that shuts down an Oracle Database instance.
    EnumerationSpecifies the database startup mode.
    EnumerationDefines the level of PL/SQL trace for the OracleTrace component.
    EnumerationDetermines how LOB data is fetched and represented.
    EnumerationDetermines the configuration of Oracle Advanced Security data encryption and data integrity for the Direct mode.
    EnumerationDescribes 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.
    EnumerationDefines the level of SQL trace for the OracleTrace component.
    EnumerationSpecifies a type of the SSH protocol authentication.
    EnumerationSpecifies type of the trace mode in the OracleTrace component.
    EnumerationDetermines the source where to get certificates for SSL connections in the Direct mode.
    See Also