Watch, Follow, &
Connect with Us

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

ID: 17379, Oracle Data Access Components

by Dmitry Nikolaenko Email: Anonymous

Provides high performance direct access to Oracle database server. 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 3.0  to 6.0 705 downloads
Copyright: All rights reserved

Size: 2,288,825 bytes
Updated on Fri, 01 Feb 2002 11:07:46 GMT
Originally uploaded on Mon, 14 Jan 2002 11:27:47 GMT
SHA1 Hash: E8329E5852179C3D5B8DC7AB117524BE7A28999E
MD5 Hash: AEAAB92002C5A1A6A8AC11B06BB113A2

    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.

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.

Version 3.50 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, 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
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
TConnectDialog - serves for enter username, password and server name;
TCRDBGrid - extends TDBGrid capabilities, provides visual access to
filters and incremental search;
TVirtualTable - dataset stores data in memory.

Using Oracle Data Access gives you the following advantages:

- Doesn't require Oracle's software on client side with Net option;
- No distributing, installing and configuring the BDE and ODBC;
- You can use any Delphi Professional Edition to develop
client/server applications;
- Enables you to use many Oracle specific features;
- Supports Oracle 8 features: BLOB, CLOB and BFile data types,
objects, arrays, references, nested tables;
- Simplifies data updating;
- Offers two way of updating data: more flexible with TOraQuery and
more easy 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 is similar
to standard BDE data access components (TDatabase, TQuery, ..);
- Supports all data-aware components;
- Includes tools such as SQL Designer to build queries,
design and debug PL/SQL blocks and Oracle Explorer to explore database schemas.

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