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.

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

• DBMonitor support
• New version of OraTools support

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 Oracle8
• 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