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
data by Borland Database Engine (BDE).

  ODAC uses Oracle Call Interface (OCI) directrly. The Oracle Call
is an application programming interface (API) that allows an application

developer to use a third-generation language's native procedures or
calls to access the Oracle database server and control all phases of SQL

statement execution. The OCI provides a library of standard database
and retrieval functions in the form of a dynamic runtime library,
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
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] <>

  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
    database tables;
  TSmartQuery - easy in using and an alternative to TOraQuery,
    builds INSERT, DELETE, UPDATE queries, automatic locking and
  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
    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

  - 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
    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
    BDE data access components (TDatabase, TQuery, ..);
  - Supports all data-aware components;
  - Include SQL Designer for build queries and design and debug PL/SQL
  - and so on.

  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