ODAC Component List

Lets you set up and control connections to Oracle.

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.

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.

Executes SQL statements, PL/SQL blocks, and stored procedures, which do not return rowsets.

Lets you retrieve and update data in a single table without writing SQL statements.

Executes stored procedures and functions. Lets you edit cursor data returned as parameter.

Component for controlling nested table data.

Lets you tune update operations for a DataSet component.

Provides an interface for connecting data-aware controls on a form and ODAC dataset components.

Executes sequences of SQL and PL/SQL statements.

Interface for monitoring dynamic SQL execution in ODAC-based applications.

Allows you to build custom prompts for usernames, passwords, and server names.

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.

Provides a straightforward way to access Oracle packages.

Allows you to transfer messages between sessions.

Allows you to quickly load data into Oracle databases.

Provides discrete transaction control over sessions. Can be used to manipulate both simple and distributed transactions.

Lets you monitor the message queue. Provides an interface for enqueuing and dequeuing messages.

Component for managing queue tables.

Component for managing queues.

Allows you to use Oracle Database Change Notifications.

Allows you to start and stop the SQL trace for a specified session. This component provides access to the DBMS_TRACE package.

Translates error messages.

Loads data to and from a dataset.

Integrates ODAC components into BDE-based applications.

Retrieves metadata on specified SQL object.

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.