Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 24603, Oracle Data Access Components

by Dmitry Nikolaenko Email: Anonymous

Provides high performance direct access to Oracle database using OCI or SQL*Net directly. Supports many Oracle specific features and simplifies developing of client/server applications.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For C++Builder, Version 11.0  to 11.0 258 downloads
Copyright: All rights reserved

Size: 3,847,802 bytes
Updated on Fri, 01 Jun 2007 04:42:13 GMT
Originally uploaded on Fri, 04 May 2007 10:08:07 GMT
SHA1 Hash: 93C6E0A2E836EA15C9C6E9972E5BF473EAE9DE25
MD5 Hash: 257607D0B37C5FEC8689FA1EE0C9492F

    Explore the files in this upload

Oracle Data Access Components (ODAC) library offers some nonvisual
components for Borland Delphi, C++ Builder and Kylix. They serve
for access to Oracle RDBMS. ODAC is an alternative to standard
way processing data by Borland Database Engine (BDE).

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.

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;
TOraPackage - allows to execute package procedures and functions and provides access to package variables;
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.
TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search;

Using Oracle Data Access gives you the following advantages:

- Direct access to Oracle data. No distributing, installing and configuring the BDE and ODBC;
- Doesn't require Oracle's software on client side with Net option and works directly through TCP/IP;
- Extended Oracle data types support including XML types, LOB's, objects, nested tables, references, timestamps and intervals;
- High performance controlled fetch of large data blocks;
- Optimized string and raw data storing;
- Easy work with Unicode data;
- Automatic data updating with TSmartQuery and TOraTable components;
- Automatic record locking and refreshing;
- NonBlocking mode allows to run long lasting background queries in separate threads;
- Oracle 9i scrollable cursors support;
- Transparent Application Failover support;
- Supports many Oracle specific features such as alerts, pipes and Direct Path interface;
- Separated run-time and GUI specific parts allow to create pure console applications such as CGI;
- SmartRefresh option allows two or more datasets to be synchronized automatically;
- Local sorting;
- Advanced design-time editors;
- OraTools Add-in extending design-time capabilities by set of tools to build and check queries, design and debug PL/SQL blocks and explore database schemas;
- Extended SQL tracing capabilities provided by TOraSQLMonitor component and DBMonitor application;
- Includes source code of TCRDBGrid enhanced data-aware grid control;
- Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport;
- Easy migration from BDE;
- Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications.
- and many other features.


ODAC supports Oracle 10g, 9i, 8i, 8.0 and 7.3, including Personal Edition, and Oracle 8 Lite. Following development environments are supported by ODAC:
CodeGear C++ Builder 2007
CodeGear Delphi 2007 for Win32
Turbo Delphi Professional
Turbo Delphi for .NET Professional
Turbo C++ Professional
Borland Developer Studio 2006 including support of Delphi for Win32, Delphi for .NET and C++ Builder Personality
Borland Delphi 2005
Borland Delphi 8
Borland Delphi 7
Borland Delphi 6
Borland Delphi 5
Borland C++ Builder 6
Borland C++ Builder 5
Borland Kylix 3
Borland Kylix 2
Only Professional, Enterprise and Architect editions are supported. Also ODAC does not support Kylix Open Edition.

For more information, see

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC04