Oracle Data Access Components library provides high performance direct access to Oracle database server. ODAC is a set of VCL native components for Kylix, Delphi and C++ Builder and an alternative to standard way processing data by Borland Database Engine (BDE). It supports many Oracle specific features and simplifies developing of client/server applications.

Version 4.10 of ODAC includes following components:

• TOraSession - controls server connection;
• TMemDataSet - base class for TOraDataSet and TVirtualTable;
• TOraDatSet - base class for TOraQuery and TSmartQuery;
• TOraQuery - queries execution, operates record set, flexable way updating database tables;
• TSmartQuery - easy in using and an alternative to TOraQuery, automotically builds INSERT, DELETE, UPDATE queries, automatic locking and refreshing records;
• TOraSQL - executes SQL statements, PL/SQL blocks, stored procedure;
• TOraTable - allows to retrieve and update data single table without writing SQL statement;
• TOraStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter;
• TOraNestedTable - controls nested table's data;
• TOraProvider - provides data to and applies updates from a client dataset;
• TOraScript - executes sequence of SQL and PL/SQL statements;
• TOraAlerter - allows to transfer messages between sessions;
• TOraLoader - provides quick loading data to Oracle database;
• TOraSQLMonitor - allows to monitor dynamic SQL executing in ODAC based applications;
• TOraErrorHandler - translates error messages;
• TConnectDialog - serves for enter username, password and server name;
• TVirtualTable - dataset stores data in memory.

Using Oracle Data Access Components gives you the following advantages:

• Enables you to use many Oracle specific features;
• No distributing, installing and configuring the BDE and ODBC;
• Supports Oracle 8 features: BLOB, CLOB and BFile data types, objects, arrays, references, nested tables;
• Oracle 9 scrollable cursors, timestamp and interval datatypes support;
• Simplifies data updating;
• Offers two ways of updating data: more flexible with TOraQuery and easier with TSmartQuery;
• Speeds up fetch record from database;
• Provides automatic locking and refreshing records;
• Allows to execute longtime stored procedure separated thread;
• Advanced design-time editors;
• Interface (methods, properties) of ODAC components similar to standard BDE data access components (TDatabase, TQuery ..);
• Support all data-aware components;
• Uses OraTools Add-in to build and check queries with OraDesigner, design and debug PL/SQL blocks with OraDebugger and explore database schemas with OraExplorer;
• DB Monitor support.