Delphi for delphier

September 24, 2008

Oracle Data Access Components

Filed under: Umum — ekoindri @ 12:20 pm

Oracle Data Access Components


Oracle Data Access Components

Core Lab

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

Install Oracle Data Access Components

Oracle Data Access Components home page

Tinggalkan sebuah Komentar »

Belum ada komentar.

RSS feed for comments on this post.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:


You are commenting using your account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

Buat situs web atau blog gratis di

%d blogger menyukai ini: