A Database API Component by Core Lab

ODAC uses Oracle Call Interface (OCI) directly. The Oracle Call Interface is an application programming interface (API) that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. The OCI provides a library of standard database access and retrieval functions in the form of a dynamic runtime library, ORA*.DLL, that can be linked in by the application.
Also with Net option ODAC allows to connect without Oracle client software installed on workstation. In such case ODAC requires only TCP/IP protocol and allows to build really thin database application.
Using BDE in Oracle oriented client/server applications has some deficiencies. So in consequence of BDE community get unable server specific features, use more resources, reduce speed of processing data, cumbrous distribution of an application and its administration.

ODAC includes following components:

• TOraSession - controls server connection;


• TOraQuery - queries execution, operates record set, flexible way updating database tables;


• TSmartQuery - easy in using and an alternative to TOraQuery, automatically 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;


• TBDESession - allows to integrate ODAC components into BDE based application;


• TConnectDialog - serves for enter username, password and server name;


• TVirtualTable - dataset stores data in memory.