New Features in ODAC 13.1
- Lazarus 3.0 is supported
- Added support for connect to servers with enabled Security Banners in the Direct mode
- Improved error message about a non-existent database object in another schema
New Features in ODAC 13.0
- Added support for RAD Studio 12
- Added support for Oracle 23c
- Added support for macOS Sonoma
- Added support for iOS 17
- Added support for Android 13
- Added support for nested Macros in SQL queries
- Added support Display Format for Aggregate fields
- Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption
- Improved UnicodeEnvironment support for non-Unicode Delphi versions
New Features in ODAC 12.3
- Added support for RAD Studio 11 Alexandria Release 3
- Added support for iOS Simulator ARM 64-bit target platform
- Added support for Lazarus 2.2.6
- Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
- Added support for the mathematical operations in TDADataSet.Filter
- Added support for Aggregate Fields and InternalCalc Fields
- Added ability to restore from file with TEncoding via the Dump component
- Improved detection of home directories in recent versions of Oracle
- Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
- Now valid exception will be raised instead of AV when memory can't be allocated for the large row count
New Features in ODAC 12.2
- Added support for RAD Studio 11 Alexandria Release 2
- Added support for Lazarus 2.2.2
- Added support for iOS 15
- Added support for Android 12
- Added the CloneCursor method for Query and Table components that allows sharing data between datasets
- Improved the performance of exporting to XML
- Fixed bug when a connection string parameter value contains a single quote
New Features in ODAC 12.1
- RAD Studio 11 Alexandria Release 1 is supported
- Lazarus 2.2.0 is supported
- Windows 11 is supported
- macOS Monterey is supported
New Features in ODAC 12.0
- RAD Studio 11 Alexandria is supported
- macOS ARM is supported
- Added demo project for FastReport FMX
New Features in ODAC 11.4
- Oracle 21c is supported
- RAD Studio 10.4.2 Sydney is supported
- macOS 11 Big Sur is supported
- iOS 14 is supported
- Android 11 is supported
- Performance of batch operations is improved
- Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
- The PrefetchRows option in the Direct mode is supported
- Data fetch performance in the Direct mode is improved
- LOB read/write performance is improved
New Features in ODAC 11.3
- Oracle 20c is supported
- Connection via SSL protocol is supported
- Connection via SSH protocol is supported
- Connection via HTTP tunnel is supported
- Lazarus 2.0.10 and FPC 3.2.0 are supported
- Performance of Batch Insert, Update, and Delete operations is improved
New Features in ODAC 11.2
- RAD Studio 10.4 Sydney is supported
- Lazarus 2.0.8 is supported
- macOS 64-bit in Lazarus is supported
- Mapping the FLOAT Oracle data type to the ftNumber field is added
New Features in ODAC 11.1
- Android 64-bit is supported
- Lazarus 2.0.6 is supported
- Oracle 19c is supported
- Now Trial edition for macOS and Linux is fully functional
- Long database object names is supported
New Features in ODAC 11.0
- macOS 64-bit is supported
- Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
New Features in ODAC 10.4
- Lazarus 2.0.2 is supported
- CommandTimeout is supported
- Support for ChangePassword in the Direct mode is improved
- The DefaultSortType property for TVirtualTable is added
- Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
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
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
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
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
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
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
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
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
New Features in ODAC 9.3
- RAD Studio 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.MasterFieldsNullable property is added
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
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
- Flexible management of conditions in the WHERE clause 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
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
New Features in ODAC 8.6
- Rad Studio XE3 Update 1 is now required
- C++Builder 64-bit for Windows is supported
New Features in ODAC 8.5
- Rad Studio XE3 is supported
- Windows 8 is supported
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
- FieldType ftOraTimeStamp is added
New Features in ODAC 8.1
- Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
- Mac OS X and iOS in RAD Studio XE2 is supported
- FireMonkey support is improved
- Lazarus 0.9.30.2 and FPC 2.4.4 are supported
- Mac OS X 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
New Features in Oracle Data Access Components 8.00
- 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
New Features in Oracle Data Access Components 7.20
- Lazarus 0.9.30 and FPC 2.4.2 is 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
New Features in Oracle Data Access Components 7.10
- Support for connection with using Service Name in the Direct mode
- Support for the ChangePassword functionality in the Direct mode
- Improved returning cursors with different fields list from TOraStoredProc
- 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
New Features in Oracle Data Access Components 7.00
- Embarcadero RAD Studio XE suppored
- Support of National parameter to Package Wizard
- Ability to lock records in the CachedUpdate mode
- Ability to send call stack information to the dbMonitor component
- Added ability to lock records in the CachedUpdate mode
- Added OnStart, OnCommit, OnRollback events to TDATransaction
- Added OnInfoMessage event
- Added support for dbMonitor 3
- Added support for using user-defined UpdatingTable when ODAC cannot detect a table list for a query
- Updated Oracle client version detection for Linux by OCI API
- Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
- Now Required flag is set for UpdatingTable fields only
- Now the AssignConnect method copies transaction state
New Features in Oracle Data Access Components 6.90
- Embarcadero RAD Studio 2010 supported
- Support for BINARY_FLOAT and BINARY_DOUBLE data types in TOraArray
- Support for reading a comma separated list of aliases from TNSNAMES.ORA
- Support for ALTER .. COMPILE in GetCompilationError
- Unicode support in CLOB attributes of OBJECT type
- Added EnableOraTimeStamp option of TOraSession
- Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
- Added support for Free Pascal under Linux
- Added NoPreconnect property to TOraScript for executing CONNECT and CREATE DATABASE commands
- The Disconnected property to TCustomDADataSet
- Now the value from the master dataset has priority over the DefaultExpression value
New Features in Oracle Data Access Components 6.80
- Free Pascal under Linux supported
- Added NoPreconnect property to TOraScript for executing CONNECT and CREATE DATABASE commands
New Features in Oracle Data Access Components 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
New Features in Oracle Data Access Components 6.50
- Improved support of default field values
- The new component for metadata receiving added
- Added support of TWideMemoField
- The BCD types supported
New Features in Oracle Data Access Components 6.25
New Features in Oracle Data Access Components 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
New Features in Oracle Data Access Components 6.10
- C++Builder 2007 supported
New Features in Oracle Data Access Components 6.05
New Features in Oracle Data Access Components 6.00
New functionality:
- Delphi 2007 for Win32 supported
- Implemented Disconnected Model for working offline and automatically connecting and disconnecting
- Implemented Local Failover for detecting connection loss and implicitly re-executing some operations
- LargeInt fields supported
- WideMemo field type in Delphi 2006 supported
- Added DataSet Manager to control project datasets
- Integration with OraDeveloper Tools 2.00 added
- New TCRBatchMove component for transferring data between all types of TDataSet descendants added
- Data export and M:Devart.Dac.TVirtualTable.LoadFromFile(System.String,System.Boolean) to/from XML supported
- Support for sending messages to DBMonitor from any point in your program added
Support for more Oracle server functionality:
Extensions and improvements to existing functionality:
Usability improvements:
New Features in Oracle Data Access Components 5.70
New Features in Oracle Data Access Components 5.55
- Added ability to automatically prepare queries (TCustomDADataSet.Options.AutoPrepare)
- Added ability to synchronize positions in different DataSets (TCustomDADataSet.GotoCurrent)
New Features in Oracle Data Access Components 5.50
- Delphi 2005 supported
- Performance of Net-option improved
- Added Schema property for TOraSession component
- Added ProxySession property for TOraSession component
New Features in Oracle Data Access Components 5.10
- Local sort ability using IndexFieldNames property added
- T:Devart.Odac.OraDataAdapter component for Delphi 8 added
New Features in Oracle Data Access Components 5.00
- Support for Delphi 8 added
- Oracle 10g support added
- Connection pooling supported
- Character conversion supported in Oracle 9i in Direct mode
- Unicode character data supported in Direct mode
- Support TIMESTAMP, INTERVAL data types in Direct mode
- Support for Oracle internal NUMBER datatype added in Direct mode
- Performance improved
- TCRGrid sources in Standard and Net editions
- .NET Windows Forms demo project added
- ASP.NET demo project added
New Features in Oracle Data Access Components 4.50
- XMLTYPE datatype support added
- WideString support added to work with Unicode character data
- Transparent Application Failover support added
New Features in Oracle Data Access Components 4.15
- Support for Oracle internal NUMBER datatype added. Allows to work with high precision numbers without accuracy losses
New Features in Oracle Data Access Components 4.10
- Support for Oracle 9i NOT FINAL objects added
- TIMESTAMP and INTERVAL support for Oracle objects added
25-Dec-02 Oracle Data Access Components 4.05 new features:
- 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
New Features in Oracle Data Access Components 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. Now if user does not explicitly call Prepare method before opening dataset there is no additional roundtrip to server for select-list describe (OCIStmtExecute(DESCRIBE_ONLY) call). I.e. Open (Execute for SELECT) without Prepare is performed in a more optimal way.
New Features in Oracle Data Access Components 3.90
New Features in Oracle Data Access Components 3.85
- DBMonitor support
- New version of OraTools support (v. 2.50)
New Features in Oracle Data Access Components 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
New Features in Oracle Data Access Components 3.60
New Features in Oracle Data Access Components 3.50
- supports Kylix 2
- multibytes charsets support
- direct lob access support
- using OraTools Add-in
New Features in Oracle Data Access Components 3.30
- supports Oracle 9i
- Net edition for Kylix
New Features in Oracle Data Access Components 3.20
- supports Delphi 6
- new version of OraDesigner
- OraExplorer
- printed documentation
- BDE Migration Wizard
New Features in Oracle Data Access Components 3.00
- using standard TParam object
- separate run- and design-time packages
- get original name of fields
- retrieve field's default value
- in Direct mode support
- Kylix ready
New Features in Oracle Data Access Components 2.50
- supports multiple Oracle Homes
- supports Borland SQL Monitor
- TOraSQLMonitor component
- default session
- customizable connect dialog
- ConnectDialog and Threads demos added
New Features in Oracle Data Access Components 2.20
- supports C++Builder 5
- macros in update SQL
New Features in Oracle Data Access Components 2.10
- customized TSmartQuery data updating
- supports DML array operations
- macros in TOraSQL and TOraScript
- TOraLoader component
- supports Oracle 8 Lite
- easy installation
New Features in Oracle Data Access Components 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
- Alerter, Arrays, BFile, BLOBPics, DLL, DMLArray, FetchCursors, NestedTables, Objects, Refs demos added
New Features in Oracle Data Access Components 1.85
- TOraProvider component
- TBDESession component
- Supports Oracle 8i
- C++Builder 4 package
New Features in Oracle Data Access Components 1.75
- TOraTable component
- TStoredProc component
New Features in Oracle Data Access Components 1.70
- Supports BLOB and CLOB data types Oracle 8
- Supports nested tables
- TVirtualTable component
- Embeded SQL Designer with PL/SQL debugger
- C++Builder version
New Features in Oracle Data Access Components 1.50
- Supports native interface Oracle 8.0
- Supports PL/SQL tables
- TOraErrorHandler