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
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
Executes SQL statements, PL/SQL blocks, and stored procedures, which do not return
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
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
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
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.
Retrieves metadata on specified SQL object.
Represents data encryption and decryption in client application.
Integrates ODAC components into BDE-based applications.
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.
The new versions of DAC products with support for RAD Studio XE4, iOS and the NEXTGEN compiler!
New Release of Delphi Data Access Components and VirtualTable
RAD Studio XE3 Support in DACs and VirtualTable!
"We have developed a client server application using Oracle 11.g in a biggest Hospital
in Greece about 400 users (Delphi5 and ODAC 6.9) this is working fantastic..." >>
Executive Manager of Pefki Software Company
You might be also interested in:
Oracle management tools:
Delphi data access components for:
Universal Delphi data access components for any databases:
Oracle data access in other technologies: