ODAC

Ora Unit Members

This unit contains main components of ODAC.

Classes

Name Description

TBFileField

A class representing BFile field in dataset.

TCursorField

A class representing REF CURSOR field in dataset.

TCustomOraQuery

A base class defining functionality for descendent classes which access database using SQL statements.

TOraChangeNotification

A component for keeping information in local dataset up-to-date through receiving notifications.

TOraChangeNotificationOptions

Used to specify how query notifications will be generated.

TOraConnectionSSLOptions

A class for setting up the SSL options.

TOraDataSet

A class defining the Oracle functionality for a dataset.

TOraDataSetField

A class providing access to Oracle nested datasets.

TOraDataSetOptions

This class allows setting up the behaviour of the TOraDataSet class.

TOraDataSetOptionsDS

This class allows setting up the behaviour of the TOraDaatSet class (this property is obsolete).

TOraDataSource

TOraDataSource provides an interface between an ODAC dataset components and data-aware controls on a form.

TOraEncryptor

The class that performs encrypting and decrypting of data.

TOraIntervalField

A class providing access to the Oracle interval fields.

TOraMetaData

A component for obtaining metainformation about database objects from the server.

TOraNestedTable

A component for controlling nested table data.

TOraNumberField

A class providing access to the Oracle number fields.

TOraParam

A class that is used to set the values of individual parameters passed with queries or stored procedures.

TOraParams

Used to control TOraParam objects.

TOraPoolingOptions

This class allows setting up the behaviour of the connecton pool.

TOraQuery

A component for executing queries and operating record sets. It also provides flexible way to update data.

TOraReferenceField

A class representing an Oracle REF field in a dataset.

TOraSession

A component for maintaining connection to an Oracle database.

TOraSessionOptions

This class allows setting up the behaviour of the TOraSession class.

TOraSQL

A component for executing SQL statements and calling stored procedures on the database server.

TOraStoredProc

A component for accessing and executing stored procedures and functions.

TOraTimeStampField

A class providing access to the Oracle timestamp fields.

TOraTrace

A component allowing starting and stopping a SQL trace for a specified session. This component provides access to the DBMS_TRACE package.

TOraUpdateSQL

A component for tuning update operations for the DataSet component.

TOraXMLField

A class providing access to the Oracle SYS.XMLTYPE objects.

Types

Name Description

TConnectChangeEvent

This type is used for the TOraSession.OnConnectChange event.

TFailoverEvent

This Type is used for the TOraSession.OnFailover event.

TOraChangeNotificationEvent

This type is used for the TOraChangeNotification.OnChange event.

TPlSqlTraceMode

Specifies the level of PL/SQL trace.

TSqlTraceMode

Specifies the level of SQL trace statistics level.

Enumerations

Name Description

TFailoverState

Indicates the failover state.

TFailoverType

Specifies the failover type.

TOraIsolationLevel

Specifies the way the transactions containing database modifications are handled.

TRefreshMode

Defines when to refresh an editing record.

TSequenceMode

Specifies the method used internally to generate sequenced field.

Variables

Name Description

DefSession

Read this variable to get pointer to default session object. Same as DefaultSession function.

OraQueryCompatibilityMode

All TOraQuery components in project become editable, and can be modified by the end users.

Sessions

Holds pointers to all TOraSession objects of an application.

UseDefSession

When set to True enables TOraDataSet and TOraSQL components to use default session if they are not attached to any session.
© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback