See Also

Devart.Data.Oracle Assembly

See AlsoDevart.Data.OracleSend comments on this topic.

Devart.Data.Oracle Namespace

Inheritance Hierarchy

Classes

ClassDescription
DirectUtilsUse this class to configure the packet size in the OracleConnection.Direct mode.
NativeOracleArrayRepresents an Oracle collection (VARRAY).
NativeOracleObjectRepresents a Oracle object of type defined by user.
NativeOracleObjectBaseRepresents an object of any Oracle object type defined by the user (Object, VARRAY or Nested table).
NativeOracleTableRepresents Oracle Nested table type.
OracleAlertRepresents Oracle alert message.
OracleAlerterManages Oracle alerts.
OracleAlerterAlertEventArgsProvides data for the OracleAlerter.Alert event of the OracleAlerter class.
OracleAlerterErrorEventArgsProvides data for the OracleAlerter.Error event of the OracleAlerter class.
OracleAlerterFinishEventArgsProvides data for the OracleAlerter.Stopped event of the OracleAlerter class.
OracleAnyDataRepresents Oracle SYS.ANYDATA type.
OracleArrayRepresents a client-side cached Oracle collection (VARRAY).
OracleArrayDataReaderAllows to read a forward-only stream of rows from an OracleArray or OracleTable.
OracleAttributeRepresents an attribute of the OracleObject type.
OracleAttributeCollectionRepresents attributes of Oracle object type.
OracleBFileRepresents a managed OracleBFile object to work with the Oracle BFILE data type.
OracleClientFactoryRepresents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle.
OracleCommandRepresents a SQL statement, PL/SQL statement, or stored procedure to execute against an Oracle database.
OracleCommandBuilderAutomatically generates single-table commands used to reconcile changes made to a DataSet with the associated Oracle database.
OracleConnectionRepresents an open connection to an Oracle database.
OracleConnectionErrorEventArgsProvides data for the OracleConnection.Error event of the OracleConnection class.
OracleConnectionStringBuilderGenerates automatically connection strings used to connect to an Oracle database.
OracleCursorRepresents an Oracle REF CURSOR and value of cursor field.
OracleDataAdapterRepresents a set of data commands and a database connection that are used to fill the DataSet and update an Oracle database.
OracleDataReaderReads a forward-only stream of rows from an Oracle database.
OracleDataSetRepresents an in-memory cache of data with support for Oracle-specific features.
OracleDataSourceEnumeratorProvides a mechanism for enumerating all known Oracle servers (TNS aliases).
OracleDataTableRepresents a single object that provides all of the functionality needed to retrieve and manipulate data from an Oracle data source.
OracleDependencyRepresents a dependency between an application and an Oracle database.
OracleErrorRepresents an Oracle error returned by the server.
OracleErrorCollectionCollects errors of an exception generated by dotConnect for Oracle. This class cannot be inherited.
OracleExceptionThe exception that is generated when Oracle returns an error.
OracleFailoverEventsArgsProvides data for the OracleConnection.Failover event of the OracleConnection class.
OracleGlobalizationManages the Oracle globalization settings of the application, and local computer. Oracle globalization settings of the local computer are read-only.
OracleHomeRepresents an Oracle home.
OracleHomeCollectionRepresents a list of available Oracle homes.
OracleInfoMessageEventArgsProvides data for the OracleConnection.InfoMessage event.
OracleLoaderServes to load external data into the Oracle database.
OracleLoaderColumnRepresents the attributes for column loading.
OracleLoaderColumnCollectionRepresents a collection of columns relevant to a OracleLoader.
OracleLoaderErrorEventArgsProvides data for the OracleLoader.Error event of the OracleLoader class.
OracleLobRepresents LOB data type stored on an Oracle server.
OracleMetaDataCollectionNamesEnumerates collection names you can use for metadata retrieval purposes.
OracleMonitorMonitors dynamic SQL execution in applications that use dotConnect for Oracle.
OracleNotificationEventArgsProvides data for the OracleDependency.OnChange event.
OracleNotificationRequestRepresents a notification request to be subscribed in the database.
OracleNumberMappingRepresents a mapping between .NET and Oracle number types.
OracleNumberMappingCollectionRepresents a collection of OracleNumberMapping objects.
OracleObjectRepresents a client-side cached Oracle object of type defined by user.
OraclePackageProvides access to packages stored in the Oracle database.
OracleParameterRepresents a parameter to a OracleCommand, and optionally, its mapping to DataSet columns.
OracleParameterCollectionCollects all parameters relevant to a OracleCommand as well as their respective mappings to DataSet columns.
OraclePermissionEnables dotConnect for Oracle to ensure that a user has an adequate security level to access an Oracle database. This class cannot be inherited.
OraclePermissionAttributeAssociates a security action with a custom security attribute.
OraclePipeRepresents Oracle pipe.
OraclePipeMessageRepresents elementary piece of data to transfer through Oracle pipe.
OraclePipeMessageCollectionRepresents data transferred through Oracle pipe.
OracleProviderException 
OracleProviderFactoryRepresents a factory required to create inheritors of generic base classes to use with dotConnect for Oracle.
OracleQueueRepresents Oracle Streams Advanced Queuing (AQ).
OracleQueueAdminManages Oracle Streams Advanced Queuing (AQ) configuration and administration information.
OracleQueueAgentIdentifies a producer or a consumer of a message.
OracleQueueAgentCollectionRepresents a collection of OracleQueueAgent objects.
OracleQueueDequeueOptionsRepresents the options available for the dequeue operation.
OracleQueueEnqueueOptionsRepresents the options available for the enqueue operation.
OracleQueueMessageRepresents queue messages.
OracleQueueMessageEventArgsProvides data for the OracleQueue.OnMessage event of the OracleQueue class.
OracleQueueMessagePropertiesDescribes the information that AQ uses to manage individual messages.
OracleQueueOptionsQueue options that are used upon creation.
OracleQueueTableRepresent queue table for messages of a predefined type.
OracleQueueTableOptionsQueue table properties, that are used for its creation.
OracleRefRepresents a reference to the object (REF).
OracleRowUpdatedEventArgsProvides data for the OracleDataAdapter.RowUpdated event.
OracleRowUpdatingEventArgsProvides data for the OracleDataAdapter.RowUpdating event. This class cannot be inherited.
OracleScriptServes to execute series of SQL statements separated by special symbols, like SQL*Plus scripts.
OracleSelectStatementRepresents a SELECT statement.
OracleSqlStatementRepresents a SQL statement.
OracleSqlStatementCollectionRepresents a list of OracleSqlStatement objects.
OracleTableRepresents a client-side cached Oracle Nested table type.
OracleTraceControls server side SQL and PL/SQL tracing.
OracleTransactionRepresents a SQL transaction to be made in the Oracle database.
OracleTypeRepresents any Oracle object type defined by the user such as OracleObject, OracleArray or OracleTable.
OracleXmlRepresents an Oracle XMLType instance.
SqlStatementExecuteEventArgsProvides data for the OracleScript.SqlStatementExecute event of the OracleScript class.

Interfaces

InterfaceDescription
ICustomOracleArrayRepresents an Oracle ARRAY.
ICustomOracleObjectRepresents an Oracle OBJECT.

Enumerations

EnumerationDescription
OracleConnectModeHolds fields which allow to open a session with specified privileges.
OracleDbTypeSpecifies the data type of a field, property, OracleParameter or OracleAttribute.
OracleFailoverStateRepresents Transparent Application Failover state.
OracleFailoverTypeRepresents Transparent Application Failover type.
OracleLobOpenModeSpecifies whether an OracleLob should be opened in read-only or read/write mode.
OracleNotificationInfoSpecifies the operation, for which a notification is received from Oracle server.
OracleNotificationTypeSpecifies the type of notification received from Oracle server.
OracleNumberTypeEnumerates main Oracle number types.
OracleObjectTypeDescribes 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.
OracleQueryBasedNotificationModeSpecifies the mode for query-based notifications.
OracleQueueCompatibleSpecifies the lowest database version with which the queue is compatible.
OracleQueueDeliveryModeSpecifies 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.
OracleQueueDequeueModeSpecifies how the messages will be dequeued.
OracleQueueMessageGroupingSpecifies the message grouping behaviour.
OracleQueueMessageStateSpecifies the state of the message.
OracleQueueNavigationSpecifies which message will be dequeued next.
OracleQueuePrivilegeThe privilege to enqueue or dequeue messages on the queue.
OracleQueueSequenceDeviationSpecifies whether the message being enqueued should be dequeued before other messages already in the queue.
OracleQueueSortOrderSpecifies which parameters are used to order messages in the queue. The order is ascending.
OracleQueueSystemPrivilegeThe AQ administration privilige granted to or revoked from a user or role.
OracleQueueTypeSpecifies whether the queue is normal, service or nonpersistent with RAW message payload.
OracleQueueVisibilitySpecifies the visibility options for an enqueue operation.
PlSqlTraceModeDefines the level of PL/SQL trace for the OracleTrace component.
ReadLobModeDetermines how LOB data is fetched and represented.
SqlPlusStatementTypeDescribes 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.
SqlTraceModeDefines the level of SQL trace for the OracleTrace component.
TraceStateSpecifies type of the trace mode in the OracleTrace component.

Structures

StructureDescription
OracleBinaryRepresents a variable-length binary data to be stored in or retrieved from a database.
OracleDateRepresents the Oracle DATE data type.
OracleIntervalDSRepresents 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.
OracleIntervalYMRepresents the Oracle INTERVAL YEAR TO MONTH data type. Each object of the OracleIntervalYM class stores a period of time in years and months.
OracleNumberRepresents the Oracle NUMBER or any numeric type.
OracleQueueMessageIdRepresents the system-generated identification of the message.
OracleStringRepresents a variable-length stream of characters to be stored in or retrieved from the database.
OracleTimeStampRepresents the Oracle TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE data types.

Delegates

DelegateDescription
OnChangeEventHandlerRepresents the method that will handle the OracleDependency.OnChange event of an OracleDependency.
OracleAlerterAlertEventHandlerRepresents the method that will handle the OracleAlerter.Alert event of an OracleAlerter.
OracleAlerterErrorEventHandlerRepresents the method that will handle the OracleAlerter.Error event of an OracleAlerter.
OracleAlerterFinishEventHandlerRepresents the method that will handle the OracleAlerter.Stopped event of an OracleAlerter.
OracleConnectionErrorEventHandlerRepresents the method that will handle the OracleConnection.Error event of an OracleConnection.
OracleFailoverEventHandlerRepresents the method that will handle the OracleConnection.Failover event of an OracleConnection.
OracleInfoMessageEventHandlerRepresents the method that will handle the OracleConnection.InfoMessage event of an OracleConnection.
OracleLoaderErrorEventHandlerRepresents the method that will handle the OracleLoader.Error event of an OracleLoader.
OracleQueueMessageEventHandlerRepresents the method that will handle the OracleQueue.OnMessage event of an OracleQueue.
OracleRowUpdatedEventHandlerRepresents the method that will handle the OracleDataAdapter.RowUpdated event of an OracleDataAdapter.
OracleRowUpdatingEventHandlerRepresents the method that will handle the OracleDataAdapter.RowUpdating event of an OracleDataAdapter.
SqlStatementExecuteEventHandlerRepresents the method that will handle the OracleScript.SqlStatementExecute event of an OracleScript.

See Also

Devart.Data.Oracle Assembly

 

 


© 2002 - 2013 Devart. All Rights Reserved.