Basic ODAC components are included in all ODAC editions. There are additional components
in ODAC Professional and Developer Edition. The
Editions
page gives full description of features and included components of
each edition.
|
TOraSession
Lets you set up and control connections to Oracle.
|
|
TOraQuery
Uses SQL statements to retrieve data from Oracle tables and pass it to one or more
data-aware components through a TDataSource object. This component provides a mechanism
for updating data in Oracle.
|
|
TSmartQuery
A more efficient query component. This component is aware of all the fields that
belong to a table being updated and performs on-demand full row retrieval with Expand
Fields. A traffic-efficient alternative to TOraQuery for working with large tables
with lots of fields. Includes Smart Refresh functionality in Professional and Developer
Editions.
|
|
TOraSQL
Executes SQL statements, PL/SQL blocks, and stored procedures, which do not return
rowsets.
|
|
TOraTable
Lets you retrieve and update data in a single table without writing SQL statements.
|
|
TOraStoredProc
Executes stored procedures and functions. Lets you edit cursor data returned as
parameter.
|
|
TOraNestedTable
Component for controlling nested table data.
|
|
TOraUpdateSQL
Lets you tune update operations for a DataSet component.
|
|
TOraDataSource
Provides an interface for connecting data-aware controls on a form and ODAC dataset
components.
|
|
TOraScript
Executes sequences of SQL and PL/SQL statements.
|
|
TOraSQLMonitor
Interface for monitoring dynamic SQL execution in ODAC-based applications.
|
|
TConnectDialog
Allows you to build custom prompts for usernames, passwords, and server names.
|
|
TVirtualTable
Provides dataset functionality for data that has no real database connection. This
component is placed on the Data Access page of the Component palette, not on the
Oracle Access page.
|
|
TVirtualDataSet
Dataset that wraps arbitrary non-tabular data.
|
|
TOraPackage
Provides a straightforward way to access Oracle packages.
|
|
TOraAlerter
Allows you to transfer messages between sessions.
|
|
TOraLoader
Allows you to quickly load data into Oracle databases.
|
|
TOraTransaction
Provides discrete transaction control over sessions. Can be used to manipulate both
simple and distributed transactions.
|
|
TOraQueue
Lets you monitor the message queue. Provides an interface for enqueuing and dequeuing
messages.
|
|
TOraQueueTable
Component for managing queue tables.
|
|
TOraQueueAdmin
Component for managing queues.
|
|
TOraChangeNotification
Allows you to use Oracle Database Change Notifications.
|
|
TOraTrace
Allows you to start and stop the SQL trace for a specified session. This component
provides access to the DBMS_TRACE package.
|
|
TOraErrorHandler
Translates error messages.
|
|
TOraProvider
Loads data to and from a dataset.
|
|
TOraMetaData
Retrieves metadata on specified SQL object.
|
|
TOraEncryptor
Represents data encryption and decryption in client application.
|
|
TCRBatchMove
Transfers data between all types of TDataSet descendants. This component is placed
on the Data Access page of the Component palette, not on the Oracle Access page.
|