Watch, Follow, &
Connect with Us

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


ID: 25759, 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 Delphi, Version 5.0  to 12.0 120 downloads
Copyright: All rights reserved


Size: 4,121,381 bytes
Updated on Fri, 05 Sep 2008 08:35:26 GMT
Originally uploaded on Wed, 30 Jul 2008 07:19:28 GMT
SHA1 Hash: A0614F22776458B7987E8653E2C7E57C3E05A674
MD5 Hash: F9F08FE1C7659FD170880434FC10AF67

    Explore the files in this upload

Description
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.

Compatibility
-------------

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:
CodeGear Delphi 2009 for Win32
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
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 http://www.devart.com/odac

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Server Response from: ETNACDC03