Oracle Data Access Components is the best way of developing an application with Delphi and Oracle

  Oracle Data Access Components (ODAC) library from CoRe Lab offers some

nonvisual components for Borland Delphi and C++ Builder. 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) directrly. The Oracle Call
Interface
is an application programming interface (API) that allows an application

developer to use a third-generation language's native procedures 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.

  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.

  In case of using BDE transfer way of data is:

[Oracle RDBMS] <> [SQL Net] <> [OCI] <> [SQL Links] <> [BDE] <>
[Application]

  ODAC works directly through Oracle Call Interface. It allows to avoid
using BDE and SQL Links:

[Oracle RDBMS] <> [SQL Net] <> [OCI] <> [Application]

Version 1.75 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, flexable way
updating
    database tables;
  TSmartQuery - easy in using and an alternative to TOraQuery,
automotically
    builds INSERT, DELETE, UPDATE queries, automatic locking and
refreshing
    records;
  TOraSQL - executes SQL statements, PL/SQL blocks, stored procedure;
  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;
  TConnectDialog - serves for enter username, password and server name;
  TOraErrorHandler - translates error messages;
  TVirtualTable - dataset stores data in memory.

Using Oracle Data Access gives you the following advantages:

  - No distributing, installing and configuring the BDE and ODBC;
  - You can use any Delphi Professional Edition to develop client/server

    application;
  - Enables you to use many Oracle specific features;
  - Supports Oracle 8 feathers: BLOB and CLOB data types, nested tables;

  - Simplifies data updating;
  - Offers two way of updating data: more flexable 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;
  - Each component have thread component editor;
  - Interface (methods, properties) of ODAC components is similar to
standard
    BDE data access components (TDatabase, TQuery, ..);
  - Supports all data-aware components;
  - Include SQL Designer for build queries and design and debug PL/SQL
blocks;
  - and so on.

Compatibility
  ODAC supports Oracle 7.3 and Oracle 8.0.

You can download trial version of ODAC 1.75.

For details Welcome to CoRe Lab's site http://www.crlab.com