Oracle Data Access Components History

This page lists the functionality added in each version of Oracle Data Access Components. To view the full changelog including bug fixes, consult the ODAC revision history.

23-Oct-08 New Features in ODAC 6.70

  • Delphi 2009 and C++Builder 2009 supported
  • Extended Unicode support for Delphi 2007 added (special Unicode build)
  • Free Pascal 2.2 supported
  • Powerful design-time editors implemented in Lazarus
  • Optimized LOB processing in Direct mode
  • Completed with more comprehensive structured Help

23-May-08 New Features in ODAC 6.50

  • Added compatibility with UniDAC
  • Improved support of default field values
  • The new component for metadata receiving added
  • Added support of TWideMemoField
  • The BCD types supported

14-Nov-07 New Features in ODAC 6.25

  • Oracle 11g supported

27-Sep-07 New Features in ODAC 6.20

  • CodeGear RAD Studio 2007 supported
  • Added ability to customize whether update SQL statements should be prepared
  • Added ability to set number of rows to be prefetched by OCI
  • Added the OnProgress event in TOraLoader

15-Jun-07 New Features in ODAC 6.10

  • C++Builder 2007 supported

16-May-07 New features in ODAC 6.05

  • Added Oracle Package Wizard that simplifies working with PL/SQL Packages

22-Mar-07 New features in ODAC 6.00

  • New functionality:
    • Delphi 2007 for Win32 supported
    • Disconnected model for working offline and automatically connecting and disconnecting supported
    • Local Failover for detecting connection loss and implicitly reexecuting some operations supported
    • LargeInt fields supported
    • WideMemo field type in Delphi 2006 supported
    • New tool for easily managing DataSets added
    • Integration with OraDeveloper Tools 2.00 added
    • New component for transferring data between all types of TDataSets descendants added
    • Data export and import to/from XML supported
    • Support for sending messages to DBMonitor from any point of your program added
  • Support for more Oracle server functionality:
    • Distributed transactions supported
    • Advanced Queuing support added
    • Change notifications functionality of Oracle 10g supported
    • DBMS_TRACE package and SQLTrace functionality supported
    • OCI Connection Pooling, Statement Caching, and Proxy Session Pooling added
    • External Procedures support added
  • Extensions and improvements to existing functionality:
    • General performance improved
    • Master/Detail functionality extensions:
      • Local Master/Detail relationship support added
      • Master/Detail relationship in CachedUpdates mode support added
    • Connection pool functionality improvements:
      • Efficiency significantly improved
      • API for draining the connection pool added
    • TOraScript component improvements:
      • Support for executing individual statements in scripts added
      • Support for executing huge scripts stored in files with dynamic loading added
      • Ability to use standard SQL*Plus tool syntax added
    • Greatly increased performance of applying updates in CachedUpdates mode
    • Working with calculated and lookup fields improvements:
      • Local sorting and filtering added
      • Record location speed increased
      • Improved working with lookup fields
    • Ability to customize update commands by attaching external components to TOraUpdateSQL objects added
    • Support for using BeforeFetch and AfterFetch events in NonBlocking mode added
    • Temporary LOBs for updating LOB fields supported
    • Support for setting connection timeout values for Direct mode added
    • Ability to include all fields in automatically generated update SQLs added
    • Support for default field value expressions added
  • Usability improvements:
    • Syntax highlighting in design-time editors added
    • Demo projects became better organized and clearer

28-Aug-06 New Features in ODAC 5.80

  • Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ supported

26-Jan-06 New features in ODAC 5.70

  • Support for Delphi 2006 added

31-May-05 New features in ODAC 5.55

  • Ability of automatic preparing query with TCustomDADataSet.Options.AutoPrepare property added
  • Ability to synchronize position at different DataSets with TCustomDADataSet.GotoCurrent method added
  • Optimized TOraSQLMonitor BLOB parameters processing

24-Jan-05 New features in ODAC 5.50

  • Support for Delphi 2005 added
  • Performance of Net option improved
  • Ability to change the current schema of the session with TOraSession.Schema property added
  • Ability to connect middle-tier application clients with TOraSession.ProxySession property added

30-Jun-04 New features in ODAC 5.10

  • Local sorting
  • OraDataAdapter component for Delphi 8

09-Apr-04 New features in ODAC 5.00

  • Support for Delphi 8 added
  • Oracle 10g support added
  • Connection pooling support
  • Character conversion supported in Oracle 9i with Net option
  • Unicode character data supported with Net option
  • Support TIMESTAMP, INTERVAL data types with Net option
  • Support for Oracle internal NUMBER datatype added with Net option
  • Performance improved
  • TCRGrid sources in Standard and Net editions
  • .NET Windows Forms demo project added
  • ASP.NET demo project added

08-Oct-03 New features in ODAC 4.50

  • XMLTYPE datatype support added
  • WideString support added to work with Unicode character data
  • Transparent Application Failover support added

05-Jun-03 New features in ODAC 4.15

  • Support for Oracle internal NUMBER datatype added. Allows to work with high precision numbers without accuracy losses.
  • new class TOraNumber
  • new class TOraNumberField
  • new class TDAParam

30-Jan-03 New features in ODAC 4.10

  • Support for Oracle 9i NOT FINAL objects added
  • TIMESTAMP and INTERVAL support for Oracle objects added

25-Dec-02 New features in ODAC 4.05

  • Transaction control schema changed. Now TOraSession.InTransaction shows actual user transaction state on server (implicit commit and rollback are considered).
  • DBMonitor client implementation moved to COM server. Now ODAC is incompatible with DBMonitor 2.02 or lower.
  • LOB attributes support for object fields added
  • Temporary LOBs support added
  • Constants ftTimeStampTZ and ftTimeStampLTZ added. Used in TOraTimeStampField.
  • UROWID support for index organized tables added
  • Option ConvertEOL added

30-Sep-02 New features in ODAC 4.00

  • Delphi 7 support
  • Kylix 3 for C++ support
  • Oracle 9 scrollable cursors support
  • New memory management model for ftString and ftVarBytes types. Allows significantly decrease memory usage on large tables fetch. Controlled by FlatBuffers dataset option.
  • RAW datatype support (as ftVarBytes)
  • Support for complex fields (blobs, objects etc.) in CachedUpdates mode
  • New 'Prepare' schema

30-Aug-02 New features in ODAC 3.90

  • Kylix 3 support

09-Aug-02 New features in ODAC 3.85

18-Jul-02 New features in ODAC 3.80

  • Oracle9 timestamp and interval datatypes support
  • Performance optimization for queries with many fields, especially for TSmartQuery and TOraTable
  • Runtime packages division for Delphi6, C++Builder6, Kylix, Kylix2, see manual
  • Auto generation RETURNING clause for LOBs added to design-time component editor

21-Mar-02 New features in ODAC 3.60

  • supports C++Builder 6

14-Dec-01 New features in ODAC 3.50

  • supports Kylix 2
  • multibytes charsets support
  • direct lob access support
  • using OraTools Add-in

12-Oct-01 New features in ODAC 3.30

  • supports Oracle 9i
  • Net edition for Kylix

08-Aug-01 New features in ODAC 3.20

  • supports Delphi 6
  • new version of OraDesigner
  • OraExplorer
  • printed documentation
  • BDE Migration Wizard

20-Feb-01 New features in ODAC 3.00

  • using standard TParam object
  • separate run- and design-time packages
  • get original name of fields
  • retrieve field's default value
  • support Net option
  • Kylix ready

11-Jul-00 New features in ODAC 2.50

  • support multiple Oracle Homes
  • support Borland's SQL Monitor
  • TOraSQLMonitor component
  • default session
  • customizable connect dialog

30-Mar-00 New features in ODAC 2.20

  • support C++Builder 5
  • macros in update SQL

10-Jan-00 New features in ODAC 2.10

  • customized TSmartQuery data updating
  • supports DML array operations
  • macros in TOraSQL and TOraScript
  • TOraLoader component
  • supports Oracle 8 Lite
  • easy installation

14-Oct-99 New features in ODAC 2.00

  • supports Oracle8 Objects
  • supports Oracle8 REFs
  • supports Oracle8 Arrays
  • supports Oracle8 Nested tables
  • supports Oracle8 BFiles
  • using RETURNING with Oracle 8
  • smart refreshing
  • TOraNestedTable component
  • TOraScript component
  • TOraAlerter component
  • TBFileField component
  • TOraFile class
  • TOraLob class
  • TOraType class
  • TOraObject class
  • TOraRef class
  • TOraArray class
  • TOraNestTable class

26-May-99 New features in ODAC 1.85

  • TOraProvider component
  • TBDESession component
  • Support Oracle 8i
  • C++Builder 4 package

12-Mar-99 New features in ODAC 1.75

  • TOraTable component
  • TStoredProc component

01-Mar-99 New features in ODAC 1.70

  • Supports BLOB and CLOB data types Oracle 8
  • Supports nested tables
  • TVirtualTable component
  • Embeded SQL Designer with PL/SQL debugger
  • C++Builder supported

22-Oct-98 New features in ODAC 1.50

  • Supports native interface Oracle 8.0
  • Supports PL/SQL tables
  • TOraErrorHandler

05-Feb-98 First release of ODAC 1.00