Oracle Data Access Components (ODAC)Oracle Data Access Components (ODAC)

DevartData Access ToolsVCL Component
Version 15.0.1 (Jun 15, 2026)(1)

Native Oracle connectivity components for Delphi, C++Builder, and Lazarus.

  • Connect Delphi, C++Builder, and Lazarus applications directly to Oracle databases.
  • Execute queries, scripts, stored procedures, and database operations.
  • Access advanced Oracle database features and optimized data access.
Devart logo

Prices from:

Loading...
Available individuallyOur Price
Oracle Data Access Components (ODAC)Loading
Adds support for Oracle 12c connection modes (SYSBACKUP, SYSDG and SYSKM).
Oracle Data Access Components (ODAC) is a library of components for connecting Delphi, C++Builder, and Lazarus applications to Oracle databases. It enables applications to execute SQL queries, work with stored procedures, manage transactions, and access Oracle specific functionality through native components designed for high performance data access.

Direct and Client Connectivity Modes

Supports connections through the Oracle Client using OCI as well as direct TCP/IP connections without requiring Oracle Client installation, providing flexible deployment options.

Oracle Database Feature Support

Includes support for Oracle capabilities such as stored procedures, packages, REF cursors, advanced queuing, alerts, pipes, and change notification features.

Oracle Data Type And LOB Support

ODAC supports a wide range of Oracle data types including LOB types such as BLOB, CLOB, and NCLOB. It enables applications to read, write, and manage large objects and complex Oracle data structures while maintaining compatibility with Delphi dataset components and field mappings.

High-Performance Data Access

Implements optimized data access algorithms and efficient communication with Oracle servers to help applications perform database operations quickly and reliably.

Advanced Dataset and Transaction Handling

Provides components for querying data, executing scripts, managing transactions, and working with datasets that support sorting, filtering, and master-detail relationships.

PL/SQL And Stored Procedure Execution

ODAC provides components for executing Oracle stored procedures, functions, and PL/SQL blocks directly from applications. It supports input, output, and return parameters as well as REF cursors, allowing developers to integrate database side logic and procedural operations into application workflows.

Array DML And Batch Operations

ODAC supports Array DML operations that allow applications to execute SQL statements for multiple records in a single call. This approach reduces network communication with the Oracle server and improves performance when inserting, updating, or deleting large volumes of data.

Connection Pooling

ODAC supports connection pooling to reuse established Oracle connections across multiple database requests. By maintaining a pool of active connections, applications can reduce the overhead associated with repeatedly opening and closing sessions, improving performance and scalability in environments with frequent database interactions.

Comprehensive Component Set

Provides components such as TOraQuery, TOraTable, TOraStoredProc, and TOraScript that allow developers to execute queries, manage tables, and automate database operations.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • VCL Component

IDE Support

  • C++Builder
  • Delphi
  • RAD Studio