Delphi

Embarcadero Delphi is an integrated development environment for Microsoft Windows applications originally developed by Borland and now owned and developed by Embarcadero Technologies. It is based on the Delphi Programming Language, which itself is a derivative of Object Pascal.

Delphi and Oracle

Delphi offers the database connectivity options:

• dbExpress. It is Embarcadero's data driver architecture that replaced the older Borland Database Engine. dbExpress is the recommended Oracle Database connectivity for Delphi, included into RAD Studio Enterprise and Architect editions.
• dbGo. It is set of VCL components and classes built around Microsoft ADO.
• BDE. Borland Database Engine is currently deprecated.

Example Delphi program connecting to Oracle

Create a new console application, save it into file OracleDemo.dpr and paste the following code:

program OracleDemo;
{$APPTYPE CONSOLE}
uses
  SysUtils, SqlExpr, DbxOracle;
var
  Conn: TSQLConnection;
  Query: TSQLQuery;
begin
  Conn := TSQLConnection.Create(nil);
  Query := TSQLQuery.Create(nil);
  try
    try
      Conn.DriverName := 'Oracle';
      Conn.Params.Add('DataBase=localhost:1521/orcl');
      Conn.Params.Add('User_Name=scott');
      Conn.Params.Add('Password=tiger');
      Conn.Connected := True;
      Query.SQLConnection := Conn;
      Query.SQL.Text := 'select * from emp';
      Query.Open;
      while not Query.Eof do begin
        Writeln(Query.Fields[0].AsString);
        Query.Next;
      end;
    except
      on E: Exception do
        Writeln(E.ClassName, ': ', E.Message);
    end;
  finally
    Query.Free;
    Conn.Free;
  end;
end.

External links

The Delphi general sources:

• Delphi on Embarcadero Technologies
• Delphi article on Wikipedia
• Delphi wiki
• Delphi libraries and tools catalog

The Oracle data access libraries for Embarcadero Delphi:

• AnyDAC from DA-SOFT Technologies. AnyDAC is a commercial high-speed data access сomponent library for Oracle and other DBMS that simplifies the task of building Delphi, C++Builder and Lazarus database applications.
• DOA from Allround Automations. DOA is a commercial set of Oracle data access VCL components for Delphi and C++Builder.
• Oracle Data Access Components (ODAC) and dbExpress driver for Oracle from Devart. ODAC is commercial data access components providing native connectivity to Oracle from Delphi, Delphi for .NET, C++Builder, Kylix, and Lazarus (Free Pascal). dbExpress driver for Oracle provides direct high performance access to Oracle database server.