ODAC Component List

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.