Watch, Follow, &
Connect with Us

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

ID: 28391, Oracle Data Access Components (ODAC) with 64-bit Support

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. Allows developing 32-bit and 64-bit applications and supports the FireMonkey application development platform.
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 Delphi, Version 5.0  to 16.0 201 downloads
Copyright: All rights reserved

Size: 8,782,558 bytes
Updated on Mon, 29 Aug 2011 07:42:02 GMT
Originally uploaded on Tue, 02 Aug 2011 07:02:52 GMT
SHA1 Hash: B2997212EFD5EC61A8868286F0624AE9D25E58D0
MD5 Hash: DB31C9B4C7F2C71F0804839AB5ED00D8

    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 the 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 the 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;
TOraDataSource - provides an interface for connecting data-aware controls on a form and ODAC dataset components
TOraProvider - provides data to and applies updates from a client dataset;
TOraScript - executes sequence of SQL and PL/SQL statements;
TOraUpdateSQL - lets you tune update operations for a DataSet component;
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;
OraDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

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 servers 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle 10g Express.

ODAC supports x86 versions of the following Oracle clients: 11g, 10g, 9i, 8i, 8.0, and 7.3.

The following development environments are supported by ODAC:

Embarcadero Deplhi XE2 for Win32 and Win64
Embarcadero C++Builder XE2
Embarcadero Deplhi XE
Embarcadero C++Builder XE
Embarcadero Delphi 2010
Embarcadero C++Builder 2010
CodeGear Delphi 2009
CodeGear C++Builder 2009
CodeGear Delphi 2007 for Win32
CodeGear C++Builder 2007
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 7
Borland Delphi 6
Borland Delphi 5
Borland C++Builder 6
Borland C++Builder 5
Lazarus and Free Pascal for Win32 and Linux (only Editions with Source Code and Trial Edition)

Only Professional, Enterprise and Architect editions are supported.

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: ETNACDC03