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.

26-Nov-18 New Features in ODAC 10.3:

  • RAD Studio 10.3 Rio is supported
  • Oracle 18c is supported
  • Implicit result sets in Oracle 12 are supported
  • The OpenNext method for opening a next cursor or implicit result set is added
  • Support of UPPER and LOWER functions for Unified SQL is added

09-Jul-18 New Features in ODAC 10.2:

  • Lazarus 1.8.4 is supported
  • Performance of data fetching in the Direct mode is improved
  • Performance of describing stored procedures in the Direct mode is improved
  • Performance of batch operations is improved
  • Demo projects for IntraWeb 14 are added
  • Now the TOraTimeStamp.AsDateTime method returns TDateTime value with milliseconds
  • Now non-compiled stored procedures can be described in the Direct mode
  • Performance of describing stored procedures in the Direct mode is improved
  • Support for TIMESTAMP WITH TIMEZONE in the Direct mode is improved

19-Sep-17 New Features in ODAC 10.1:

  • Oracle 12c connection modes (SYSBACKUP, SYSDG, SYSKM) in the Direct mode are supported
  • OS authentication in the Direct mode is supported
  • NChar literal replacement is supported

05-Apr-17 New Features in ODAC 10.0:

  • RAD Studio 10.2 Tokyo is supported
  • Linux in RAD Studio 10.2 Tokyo is supported
  • Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
  • Oracle Encryption in the Direct mode is supported
  • Oracle Data Integrity in the Direct mode is supported
  • Oracle Cloud (DBaaS) in the Direct mode is supported
  • Oracle 12c authentication in the Direct mode is supported
  • SECUREFILE in the Direct mode is supported
  • Prefetch LOBs for Oracle 11 and higher is supported
  • EDITIONABLE and NONEDITIONABLE clause is supported
  • The PrefetchLobSize option is added
  • ANYDATA is supported
  • Field size detecting for servers with multi-byte charset when UseUnicode=False is improved
  • Now NUMBER data type without fixed scale has precision=39 and scale=39 instead of 38

25-Apr-15 New Features in ODAC 9.7:

  • RAD Studio 10.1 Berlin is supported
  • Lazarus 1.6 and FPC 3.0.0 is supported
  • Support for the BETWEEN statement in TDADataSet.Filter is added
  • Data Type Mapping performance is improved
  • Performance of TDALoader on loading data from TDataSet is improved

09-Sep-15 New Features in ODAC 9.6:

  • RAD Studio 10 Seattle is supported
  • Now NULL and empty strings are different values for ftOraLob and ftOraClob parameters
  • Now Trial for Win64 is a fully functional Professional Edition
  • Support for Offset is added for DML arrays
  • Support for OraNet.PacketSize is added to improve performance in VPN and Wireless networks
  • Support for Object References in the Direct mode is added
  • Support for Object attributes with the XML data type is added

14-Apr-15 New Features in ODAC 9.5:

  • RAD Studio XE8 is supported
  • AppMethod is supported
  • Direct mode in Lazarus is supported
  • Now the Direct mode is supplied as source code
  • Support for Objects in the Direct mode is added
  • Support for XML in the Direct mode is added
  • Support for EZCONNECT in the Direct mode is added
  • Support for fields with Cursor data type in the Direct mode is added
  • Now statements with RETURN INTO clauses can return RowsAffected in the Direct mode

15-Sep-14 New Features in ODAC 9.4:

  • RAD Studio XE7 is supported
  • Lazarus 1.2.4 is supported
  • RAC server support is improved
  • Support for WITH FUNCTION clause for Oracle 12c is added
  • GetServerList doesn't cut the WORLD postfix anymore
  • The HideRowId option is added
  • Demo projects for FastReport 5 are added
  • The TCustomDADataSet.GetKeyFieldNames method is added
  • The ConstraintColumns metadata kind for the TDAMetadata component is added
  • Workaround for the bug with calling Halt in the OnCreate event is added

29-Apr-14 New Features in ODAC 9.3:

  • Delphi XE6 is supported
  • Android in C++Builder XE6 is supported
  • Lazarus 1.2.2 and FPC 2.6.4 is supported
  • SmartFetch mode for TDataSet descendants is added
  • Now update queries inside TDataSet descendants have correct owner
  • Possibility to assign external SvcCtx to connection is added
  • DataTypeMapping conversion from XMLType to ftString is added
  • DataTypeMapping conversion from Interval to ftString is added
  • The TOraDataSetOptions.MasterDetailNullable property is added

25-Dec-13 New Features in ODAC 9.2:

  • iOS in C++Builder XE5 is supported
  • RAD Studio XE5 Update 2 is now required
  • Now .obj and .o files are supplied for C++Builder
  • An ability to establish OCI and Direct connections in the same application is supported
  • New Oracle 12c connection modes are added (SYSBACKUP, SYSDG, SYSKM)
  • The AsTimeStamp property is added to the TOraTimeStamp class
  • Compatibility of migrating floating-point fields from other components is improved

19-Sep-13 New Features in ODAC 9.1:

  • RAD Studio XE5 is supported
  • Application development for Android is supported
  • Lazarus 1.0.12 is supported
  • Performance is improved
  • Automatic checking for new versions is added
  • The possibility to use conditions is added
  • IPv6 protocol support is added
  • The possibility to use ranges is added
  • Support of the IN keyword in the TDataSet.Filter property is added
  • Like operator behaviour when used in the Filter property is now similar to TClientDataSet
  • The AllowImplicitConnect option for the TOraSession component is added
  • The SQLRecCount property for the TOraQuery and TOraStoredProc components is added
  • The ScanParams property for the TOraScript component is added
  • The RowsAffected property for the TOraScript component is added
  • The UROWID data type is supported in the Direct mode

25-Apr-13 New Features in ODAC 9.0:

  • RAD Studio XE4 is supported
  • NEXTGEN compiler is supported
  • Application development for iOS is supported
  • FPC 2.6.2 and Lazarus 1.0.8 are supported
  • BINARY_DOUBLE & BINARY_FLOAT data types support in the Direct mode is added
  • Connection string support is improved
  • Possibility to encrypt entire tables and datasets is added
  • Possibility to determine if data in a field is encrypted is added
  • Support for TimeStamp, Single and Extended fields in VirtualTable is added

17-Dec-12 New Features in ODAC 8.6

  • RAD Studio XE3 Update 1 is now required
  • C++Builder 64-bit for Windows is supported

10-Sep-12 New Features in ODAC 8.5:

  • RAD Studio XE3 is supported
  • Windows 8 is supported

21-Jun-12 New Features in ODAC 8.2:

  • Update 4 Hotfix 1 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
  • Data Type Mapping support is added
  • Data Encryption in a client application is added
  • The TOraEncryptor component for data encryption is added
  • Integration with dbForge Studio for Oracle is added
  • Calling of the TCustomDASQL.BeforeExecute event is added
  • TTimeStampField support is improved

23-Nov-11 New Features in ODAC 8.1:

  • Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
  • macOS in RAD Studio XE2 is supported
  • FireMonkey support is improved
  • Lazarus and Free Pascal 2.4.4 are supported
  • macOS in Lazarus is supported
  • Linux x64 in Lazarus is supported
  • FreeBSD in Lazarus is supported
  • Oracle 11 Express Edition is supported
  • Support for the NonBlocking option is added
  • The QueryResultOnly option is added to TOraChangeNotification

15-Sep-11 New Features in ODAC 8.0:

  • Embarcadero RAD Studio XE2 is supported
  • Application development for 64-bit Windows is supported
  • FireMonkey application development platform is supported
  • Support of master/detail relationship for TVirtualTable is added
  • OnProgress event in TVirtualTable is added
  • TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string is added

28-Apr-11 New Features in ODAC 7.20

  • Lazarus 0.9.30 and FPC 2.4.2 is supported
  • Delphi XE and C++Builder XE Starter Edition are supported
  • Oracle 9, Oracle 10, and Oracle 11 authentication in the Direct mode is supported
  • Case sensitive login and password in the Direct mode is supported
  • Unicode login and password in the Direct mode is supported
  • Client Identifier in the Direct mode is supported
  • Support of BLOB, CLOB, and NCLOB data types in ToraLoader is improved
  • Support of "table of blob/clob" data type is improved

26-Jan-11 New Features in ODAC 7.10

  • Support for connection with using Service Name in the Direct mode
  • Improved returning cursors with different fields list from TOraStoredProc
  • Support for the ChangePassword functionality in the Direct mode
  • Search for the TNS_ADMIN variable in the Oracle root location in the registry
  • Checking that dataset is open on calling the TDataSet.Locate method

13-Sep-10 New Features in ODAC 7.00

  • Embarcadero RAD Studio XE supported
  • Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
  • Added ability to lock records in the CachedUpdate mode
  • Updated Oracle client version detection for Linux by OCI API
  • Support of National parameter to Package Wizard
  • Ability to send call stack information to the dbMonitor component
  • Added OnStart, OnCommit, OnRollback events to TDATransaction
  • Added OnInfoMessage event
  • Added support for dbMonitor 3
  • Now Required flag is set for UpdatingTable fields only
  • Added support for using user-defined UpdatingTable when ODAC cannot detect a table list for a query
  • Now the AssignConnect method copies transaction state

10-Sep-09 New Features in ODAC 6.90

  • Embarcadero RAD Studio 2010 supported
  • Support for BINARY_FLOAT and BINARY_DOUBLE data types in TOraArray
  • Added EnableOraTimeStamp option of TOraSession
  • Support for ALTER .. COMPILE in GetCompilationError
  • Now the value from the master dataset has priority over the DefaultExpression value
  • Unicode support in CLOB attributes of OBJECT type
  • The Disconnected property to TCustomDADataSet
  • Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
  • Support for BINARY_FLOAT and BINARY_DOUBLE data types in TOraObject
  • Support for reading a comma separated list of aliases from TNSNAMES.ORA
  • Added support for Free Pascal under Linux
  • Added NoPreconnect property to TOraScript for executing CONNECT and CREATE DATABASE commands

02-Apr-09 New Features in ODAC 6.80

  • Free Pascal under Linux supported
  • Added NoPreconnect property to TOraScript for executing CONNECT and CREATE DATABASE commands

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 is added

05-Feb-98 First release of ODAC 1.00