Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


ID: 18529, Oracle Data Access Components

by Dmitry Nikolaenko Email: Anonymous


Provides high performance direct access to Oracle 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 3.0  to 7.0 967 downloads
Copyright: All rights reserved


Size: 1,889,033 bytes
Updated on Mon, 19 Aug 2002 03:07:16 GMT
Originally uploaded on Tue, 30 Jul 2002 11:07:57 GMT
SHA1 Hash: 0DE6BD172CD054FC8130B8A35724DB3FF83DFDD0
MD5 Hash: 50E7D772A05841826E93850EF8231E44

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

- 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;
- Uses OraTools Add-in to build and check queries with OraDesigner, design and debug PL/SQL blocks with OraDebugger and explore database schemas with OraExplorer;
- and so on.

For more information, see http://www.crlab.com/odac

Server Response from: ETNACDC03