Softpedia >Windows >Programming >Components & Libraries >Oracle Data Access Components >  Changelog

Oracle Data Access Components Changelog

What's new in Oracle Data Access Components 13.2.1

May 2, 2024
  • Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required
  • Fixed internal bug with TSharedObject

New in Oracle Data Access Components 13.2.0 (Apr 24, 2024)

  • Added support for RAD Studio 12 Athens Release 1
  • Added support for Lazarus 3.2
  • Added the GetAuditActionBanner function to TOraSession
  • Added the GetUnauthorizedAccessBanner function to TOraSession
  • Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
  • Fixed bug with string value truncation when ConvertEOL=True for Oracle 11 or lower
  • Fixed bug with Connection Pooling in the Direct mode

New in Oracle Data Access Components 13.1.0 (Feb 19, 2024)

  • 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
  • Fixed bug with CLOB reading when UseUnicode=True in OCI mode
  • Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
  • Fixed bug in TOraScript with parsing the CREATE JAVA SOURCE statmets
  • Fixed bug with refresh data after DML statements executing

New in Oracle Data Access Components 13.0.0 (Nov 15, 2023)

  • 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
  • Fixed bug with "Range check error" error on describing FLOAT parameters in Stored Procedure
  • Fixed bug with moving the cursor when using Aggregate fields
  • Fixed bug with deleting a record when using Aggregated fields
  • Fixed bug with storing empty Aggregates collection in DFM
  • Fixed bug with AV when installing a package in the IDE
  • Fixed bug with AV in the CloneCursor method of the dataset
  • Fixed bug with using Aggregated and InternalCalc fields together
  • Fixed bug with duplicate resource IDs in CBuilder
  • Fixed bug with using "NOT Field LIKE" construction in Filter property

New in Oracle Data Access Components 12.3.0 (Mar 20, 2023)

  • Added support for RAD Studio 11 Alexandria Release 3
  • Added support for iOS Simulator 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
  • Fixed bug with LOBs reading in the Direct mode
  • Fixed bug with reading BFLOAT and BDOUBLE values from ANYDATA
  • Fixed bug with querying record count if SQL statement contains PIVOT

New in Oracle Data Access Components 12.2.0 (Sep 13, 2022)

  • 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 in Oracle Data Access Components 12.1.1 (Apr 12, 2022)

  • RAD Studio 11.1 Alexandria is supported
  • Lazarus 2.2.0 is supported
  • Windows 11 is supported
  • macOS Monterey is supported
  • Fixed bug with HTTPS tunneling in the Direct mode
  • Fixed bug with resetting param values when changing param values count

New in Oracle Data Access Components 12.0.2 (Dec 9, 2021)

  • The PoolId connection pool option is added
  • Fixed bug with LONG parameters in Oracle 11 and earlier
  • Fixed bug with "Unknown data type" error in OraNestedTable
  • Fixed bug with UnicodeEnvironment in pooling
  • Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
  • Fixed bug with freezing multiply connection pools in threads
  • Fixed bug with using the AsDate property when working with fields of the ftDate type
  • Fixed bug with updating the state of records at applying cached updates

New in Oracle Data Access Components 12.0.1 (Sep 14, 2021)

  • RAD Studio 11 Alexandria is supported
  • Added demo project for FastReport FMX
  • Fixed bug with string OUT parameters in Oracle 12.1
  • Fixed bug with XML reading when UnicodeEnvironment=True
  • Bug with reading string values from TOraNestedTable is fixed
  • Bug with selecting intger values from arrays is fixed
  • Fixed bug with setting a DateTime value before the year 1800 to TTimeField
  • Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
  • Fixed bug with memoty leak on Locate by field with data type mapping
  • Fixed bug with escaping wildcards in the Filter property of the DataSet component

New in Oracle Data Access Components 11.4.3 (Apr 7, 2021)

  • Demo compatibility with new a version of SecureBridge is fixed
  • Bug with an Invalid pointer operation on Fetch is fixed
  • Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed

New in Oracle Data Access Components 11.4.1 (Mar 3, 2021)

  • 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
  • Bug with connection to RAC servers in the Direct mode is fixed
  • Bug with RefreshRecord when SQLGeneratorCompatibility=True is fixed
  • Bug with calling a stored procedure using dblink is fixed
  • Bug with TOraAnyDataField.GetAsString is fixed
  • Bug with parsing a quoted schema name is fixed
  • Bug with setting the ReadOnly field property at runtime is fixed

New in Oracle Data Access Components 11.3.2 (Sep 14, 2020)

  • Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
  • Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed

New in Oracle Data Access Components 11.3.1 (Aug 27, 2020)

  • 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 in Oracle Data Access Components 11.2.5 (Jun 9, 2020)

  • Bug with describing sorted procedure parameters is fixed

New in Oracle Data Access Components 11.2.4 (Jun 4, 2020)

  • 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
  • Bug with retrieving implicit result sets after calling the Execute method is fixed
  • Bug with retrieving unchanged parameter values in the Direct mode is fixed
  • Bug with reading object fields in OCI mode for the Win64 target platform is fixed
  • Bug with SQL statements containing a JAVA clause in TOraScript is fixed
  • Bug with SELECT RowId using Database Link in Direct mode is fixed
  • Bug with Charset when Pooling is enabled is fixed
  • Bug with locating a record by a fixed string column in the Chinese locale is fixed
  • Bug with LocalMasterDetail when DataTypeMapping is enabled is fixe

New in Oracle Data Access Components 11.1.3 (Mar 11, 2020)

  • Bug with installing different editions of two or more DAC's in a single system is fixed
  • Bug with reading XML and ANYDATA object attributes is fixed
  • Bug with XML reading from Oracle 12.1 in the Direct mode is fixed
  • Bug with setting the string values to TOraArray is fixed
  • Bug with fetching data in the NonBlocking mode is fixed
  • Bug with saving BLOB to XML is fixed
  • Bug with SQL statements that contain fields with the same name from different tables is fixed
  • Bug with executing SQL statements that contain comments using the Script component is fixed
  • Bug with resetting the value of the parameter after adding a new TDACondition is fixed
  • Bug with reading a field value using the AsBytes method in Lazarus is fixed
  • Bug with using constraints after calling the Refresh method is fixed

New in Oracle Data Access Components 11.1.2 (Nov 26, 2019)

  • 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
  • Bug with with free complex TOraObject is fixed
  • Bug with UTF-8 encoding for Oracle 9 in the Direct mode is fixed
  • Bug with memory leak on session connect in the Direct mode is fixed
  • Bug with init session timezone in the Direct mode is fixed
  • Bug with rounding float values in the Direct mode is fixed
  • Bug with AV failure when using encryption is fixed
  • Bug with using the FieldOrigins property is fixed
  • Bug with the Loader component when UniDirectional set to True for source dataset is fixed
  • Bug with "Record changed by another user" error when LockMode <> lmNone is fixed
  • Bug with mapping to BCD fields when TClientDataSet is used is fixed
  • Bug with resetting the range values when executing the Refresh method is fixed
  • Several bugs that occurred when using DataSet Manager are fixed

New in Oracle Data Access Components 11.0.1 (Jul 23, 2019)

  • Update 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
  • Bug with re-executing some prepared SQL statements in the Direct mode is fixed
  • Bug with using the AsMemo method in batch operations is fixed

New in Oracle Data Access Components 10.4.10 (Jun 24, 2019)

  • 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
  • Bug with using the UTF-8 character set for Oracle 9 in the Direct mode is fixed
  • Bug with editing DataSet that contains ANYDATA fields is fixed
  • Bug with the TOraIntervalField scale is fixed
  • Bug with the AV failure when executing the Refresh method is fixed
  • Bug with calculating percentage in the OnRestoreProgress event in the TDADump class is fixed
  • Bug with the StackOverflow exception when using batch operations in CBuilder is fixed
  • Bug with using the SetRange method is fixed

New in Oracle Data Access Components 10.3.9 (Jan 21, 2019)

  • Bug with authentication of old users in Oracle 12c is fixed
  • Bug with the DML arrays that contain the TIMESTAMP values is fixed
  • Bug with describe of SYNONYM for stored procedures in the Direct mode is fixed
  • Bug with fetch data when the FieldsAsString option is set to True in the Direct mode is fixed
  • Bug with open REFCURSOR is fixed
  • Bug with AV failure in the Refresh method in RAD Studio 10.2 Tokyo on Linux is fixed

New in Oracle Data Access Components 10.3.8 (Nov 27, 2018)

  • 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
  • Bug with detecting time zone when connecting in the Direct mode is fixed
  • Bug with using an extended string in DML statements in Oracle 12 is fixed
  • Bug with using the IFILE option in TNSNAMES.ORA is fixed
  • Bug with using the FieldOrigins property is fixed
  • Bug with using the TrimFixedChar property is fixed
  • Bug with saving a dataset that contains BLOB fields to XML is fixed

New in Oracle Data Access Components 10.2.7 (Sep 18, 2018)

  • Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
  • Now the SetRange method supports Null values
  • The enumerated property FieldOrigins is added
  • The Boolean property FieldsOrigin is deprecated
  • Bug with AV when using custom constraints is fixed
  • Bug with reading LOB data in Oracle 12 is fixed
  • Bug with the RawAsString option in the Direct mode is fixed
  • Bug with the MERGE statement in the Direct mode is fixed
  • Bug with memory leak when SQL statement contains trailing ";" is fixed

New in Oracle Data Access Components 10.2.6 (Jul 9, 2018)

  • 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
  • Support for TIMESTAMP WITH TIMEZONE in the Direct mode is improved
  • Bug with AV on destroying Query that executed batch DML with LOB parameters after connection was closed is fixed
  • Bug with writing trash in the BLOB fields on executing batch DML operations in the Direct mode is fixed
  • Bug with updating a record when using the OnFilterRecord event handler is fixed
  • Bug with using encryption and CacheCalcFields option is fixed
  • Bug with using a backslash in the Filter property is fixed
  • Bug with using First method in the Master-Detail relationship is fixed

New in Oracle Data Access Components 10.1.5 (Apr 2, 2018)

  • Lazarus 1.8.2 is supported
  • ACCEPT SQL*Plus command is supported
  • Oracle 12 Extended Data Types in the Direct mode are supported
  • BFILEs in the Direct mode are supported
  • Now Detail dataset is not refreshed when Master dataset editing is started.
  • Bug with executing batch operations with iteration = 1 and offset = 0 is fixed
  • Bug with the OraNumber fields update when DMLRefresh=True is fixed
  • Bug with re-opening a filtered dataset is fixed
  • Bug with data decryption in SmartFetch mode is fixed
  • Bug with data truncation while decrypting is fixed
  • Bug with modifying TOraArrays is fixed
  • Bug with LOB prefetch is fixed

New in Oracle Data Access Components 10.1.4 (Jan 18, 2018)

  • Lazarus 1.8 and FPC 3.0.4 are supported
  • Support for custom constraints is added
  • The UseBlankValues property for the Loader component is added
  • Bug with TIMESTAMP(0) format is fixed
  • Bug with LOB prefetch when UseUnicode=True is fixed
  • Bug with fields order in TClientDataSet when using TOraProvider is fixed
  • Bug with script parsing in TDAScript is fixed
  • Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
  • Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
  • Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
  • Bug with assertion failure when using the OnFilterRecord event handler is fixed
  • Bug with AutoInc fields in TVirtualTable is fixed
  • Bug with AV in TVirtualDataSet when editing Blob is fixed

New in Oracle Data Access Components 10.1.3 (Sep 19, 2017)

  • 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
  • Bug with overload resetting in the StoredProc editor form is fixed
  • Bug with lost chars in a parameter value when ConvertEOL=True is fixed
  • Bug with retrieving data using DBMS_OUTPUT.GET_LINE is fixed
  • Bug with assertion failure in TOraPackage is fixed
  • Bug with generating SQL for batch updates is fixed
  • Bug with Integer arrays is fixed
  • Bug with the Locate method for non-Windows platforms in Lazarus is fixed
  • Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed
  • Bug with accessing a product help from the IDE menu is fixed
  • Bug with recreating fields when calling Open after Prepare is fixed
  • Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed
  • Bug with AV failure when using calculated fields in TClientDataset is fixed
  • Bug with a key violation error when executing batch operations is fixed
  • Bug with Assert when calling the Locate method in the SmartFetch mode is fixed
  • Bug with using DAC components in DataModule for Linux is fixed

New in Oracle Data Access Components 10.0.2 (May 15, 2017)

  • Bug with authentication in the Direct mode is fixed
  • Bug with Arrays retrieving in the Direct mode is fixed
  • Bug with processing NULL values in the Loader component is fixed
  • Bug with executing a query after executing a batch command is fixed
  • Bug with using the AsGuid property is fixed

New in Oracle Data Access Components 10.0.1 (Apr 6, 2017)

  • 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
  • Bug with special symbols in password in the Direct mode is fixed
  • Bug with write BLOB to SECUREFILE for Oracle XE in the Direct mode is fixed
  • Bug with single quote inside double quotes in SQL is fixed
  • Bug with TOraArray that contains FINAL objects for x86 platforms is fixed
  • Bug with resizing DML parameters array is fixed
  • Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
  • Bug with detecting parameters by name in ExecSQLEx is fixed
  • Bug with reading Memo as WideMemo is fixed
  • Bug with field name quoting in a filter expression is fixed
  • Bug with handling parameter values of BLOB type in batch operations is fixed
  • Bug with memory leak in TVirtualDataSet is fixed

New in Oracle Data Access Components 9.7.28 (Dec 24, 2016)

  • Support for object attributes with the XML type is improved
  • Bug with XML when UnicodeEnvironment=True is fixed
  • Bug with adding Calculated fields after calling Prepare is fixed
  • Bug with OraTimeStamp comparision is fixed

New in Oracle Data Access Components 9.7.27 (Nov 11, 2016)

  • Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed
  • Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
  • Bug with parameters that contain empty strings in the Direct mode is fixed
  • Bug with memory leak in the Direct mode is fixed

New in Oracle Data Access Components 9.7.26 (Nov 11, 2016)

  • TDADataSetOptions.InsertAllSetFields property is added
  • Several bugs in SmartFetch Mode are fixed
  • Bug with memory leak if a parameter has the ftUnknown data type is fixed
  • Bug with WITH clause in TOraScript for Oracle 12c is fixed
  • Bug with invalid Oracle home is fixed
  • Bug with setting the TCustomDADataSet.EOF property after fetch canceled is fixed
  • Bug with param values loss after changing TDAParam.ValueCount is fixed
  • Bug with PtrOffset function when Overflow Checking option enabled is fixed
  • Bug with the "DisposeBuf failed" error when canceling dataset changes is fixed
  • Bug with the duplicated MacroChar variable is fixed

New in Oracle Data Access Components 9.7.25 (Nov 11, 2016)

  • TVirtualDataSet component is added
  • Bug with BINARY_DOUBLE and BINARY_FLOAT stored procedure parameters in the Direct mode is fixed
  • Bug with generating INSERT or UPDATE queries when UpdatingTable is specified is fixed
  • Bug with Refresh and Locate in the NonBlocking mode is fixed
  • Bug with AV on writing BLOBs for Win64 target platform is fixed
  • Bug with AV on application closing when DLLs are used in the Trial edition is fixed
  • Bug with using parameters and column aliases in Master-Detail relation is fixed
  • Bug with assertion failure on editing data in SmartFetch mode is fixed

New in Oracle Data Access Components 9.7.24 (Nov 11, 2016)

  • Bug with batch operations is fixed
  • Bug with AV failure in TOraQueue is fixed
  • Bug with AV failure when connection is not specified is fixed
  • Bug with memory leak on reading broken data in the Direct mode is fixed

New in Oracle Data Access Components 9.7.23 (Nov 11, 2016)

  • 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
  • Bug with connection to RAC server is fixed
  • Bug with Blob and Memo OUT parameters is fixed
  • Bug with unsigned integer parameters is fixed
  • Bug with invalid value of the Fetched property is fixed
  • Bug with string truncating in params is fixed
  • Bug with dequeue objects in TOraQueue is fixed
  • Bug with AV in TOraObject after reconnect is fixed
  • Bug with Invalid type cast in the Trial edition is fixed
  • Bug with binding LONG parameters in Oracle XE 11 is fixed
  • Bug with not receiving ORA-00028 error on session kill is fixed
  • Bug with trimming CLOBs with trailing #0 in the Direct mode is fixed
  • Bug with handling international characters in the VirtualTable component is fixed
  • Bug with displaying data in grid on error at applying cached updates is fixed
  • Bug in the SetOrderBy method in case when SQL contains ';' is fixed
  • Bug with using the LIKE clause in a dataset filter is fixed
  • Bug in TVirtualTable.Assign method on NULL values in Required fields is fixed
  • Bug with HTML entities replacing on XML data loading to TVirtualTable is fixed
  • Bug with setting the SkipUnsupportedFieldTypes option of TVirtualTable is fixed
  • Bug with generating of UpdateSQL on using WITH clause is fixed
  • Behavior of TOraTable on setting KeyFields is fixed

New in Oracle Data Access Components 9.6.22 (Nov 11, 2016)

  • Data Type Mapping performance is improved
  • The bug with retrieving the path to the tnsnames.ora file is fixed
  • Bug with retrieving fields from synonyms is fixed
  • Bug with "Out of memory" on fetching SDO geometry in the Direct mode is fixed
  • Bug in OraAlerter when ConnectionTimeOut 0 is fixed
  • Bug with binding LONG parameters in Oracle XE 11 is fixed

New in Oracle Data Access Components 9.6.21 (Nov 11, 2016)

  • Performance of TDALoader on loading data from TDataSet is improved
  • Several bugs in the SmartFetch mode are fixed
  • Bug with storing Blob data for Oracle 12c in the Direct mode is fixed
  • Bug with AV failure with using Oracle Objects on the mobile platforms is fixed
  • Bug witn NetError when server has SQLNET.EXPIRE_TIME parameter value different from zero is fixed
  • Bug with setting multiple ports for RAC server to Connection string in the Direct mode is fixed
  • Bug with InputOutput string parameters of fixed length is fixed
  • Bug with record deleting in the Unidirectional mode is fixed
  • Bug with calling AfterExecute event after an invalid statement is executed in NonBlocking mode is fixed
  • Bug with memory leak on DML array binding is fixed
  • Bug with TOraAlerter in Direct mode is fixed
  • Bug with hanging query in the NonBlocking mode is fixed
  • Bug with processing the cached data in the ApplyUpdates method is fixed
  • Bug with storing some numbers with floating point is fixed
  • Bug with RecNo in the Unidirectional mode is fixed
  • Bug with AssignSvcCtx is fixed
  • Bug with XML encoding is fixed

New in Oracle Data Access Components 9.6.20 (Nov 11, 2016)

  • Bug with editing Blob and Memo fields used in local filter is fixed
  • Bug on replacing ";" with " " in SQL queries in Direct mode is fixed

New in Oracle Data Access Components 9.6.19 (Sep 10, 2015)

  • 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
  • Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
  • 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
  • Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
  • SQLMonitor behavior on using similar objects is fixed
  • Bug with endless reconnection in assigned connection is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed
  • Bug with cutting WideStrings in TOraLoader is fixed
  • Bug with OUT table parameters for Oracle 9 and 10.1 is fixed
  • Bug with using NonBlocking mode from threads is fixed
  • Bug with Charset in pooling is fixed

New in Oracle Data Access Components 9.5.18 (Sep 10, 2015)

  • Critical bug with data encryption is fixed
  • Bug with DML array of Int64 values is fixed
  • Bug in IProviderSupport.PSExecuteStatement with parsing a SQL query is fixed
  • Bug with missing IdeVer.inc in Trial version is fixed

New in Oracle Data Access Components 9.5.17 (Sep 10, 2015)

  • Critical bug when parsing SQL query with parameters is fixed
  • Bug with the Refresh method in the SmartFetch mode is fixed
  • Direct mode compilation for non-Windows platforms in Lazarus is fixed

New in Oracle Data Access Components 9.5.16 (Sep 10, 2015)

  • Bug with DMLs that return an error from Oracle 11.2.0.4 or higher in the Direct mode is fixed
  • Bug with the RETUNING clause in a statement, that contains parameters with the same name, in the Direct mode is fixed
  • Bug with using bookmarks in a filtered dataset is fixed
  • Bug with restoring the original order of records after clearing IndexFieldNames is fixed
  • Bug with refreshing DbLookupComboBox of the detail dataset when Master-Detail relationship is used is fixed
  • Bug with SQL Monitor freezing when using in a DLL is fixed

New in Oracle Data Access Components 9.5.15 (Apr 16, 2015)

  • 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
  • Bug with auto-commit transaction on closing TOraSmartQuery with SmartRefresh=True is fixed
  • Bug with detecting instant client is fixed
  • Bug with detecting default client is fixed
  • Bug with "Invalid field size" when creating fields in Delphi 5 is fixed
  • Bug with memory leak after calling GetFieldNames is fixed
  • Bug with invalid names of Master-Detail parameters is fixed
  • Bug with the 'Cannot convert type' error in the TDADataSet.RefreshRecord method when data type mapping is used is fixed
  • Bug with AV failure in the SmartFetch mode is fixed
  • Bug with AV on calling GetVersion() in C++Builder is fixed

New in Oracle Data Access Components 9.4.14 (Jan 15, 2015)

  • Lazarus 1.2.6 is supported
  • Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
  • Bug with getting package variable values is fixed
  • Bug with double calling the AfterExecute event on query Execute is fixed
  • Bug with RestoreUpdates in CachedUpdates mode is fixed
  • Bug with losing data after VirtualTable closing on SaveToStream is fixed

New in Oracle Data Access Components 9.4.13 (Nov 25, 2014)

  • Bug with connection to Oracle 8.0.x is fixed
  • Bug with editing Lob fields in the UniDirectional mode is fixed
  • Bug with setting KeyFields in TOraTable when changing the table name is fixed
  • Bug with SQL statements containing a WITH clause in TOraScript is fixed
  • Bug with AV on opening DataSet in threads is fixed
  • Bug when using table aliases in the DetailFields name is fixed
  • Bug with using UPPER and LOWER functions in filter is fixed
  • Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
  • Bug with 'Thread Error' when connecting on OS X is fixed
  • Bug with setting TParam.Value = for a parameter with the ftDate data type is fixed
  • Bug with TCustomDADataSet.FindKey is fixed
  • Bug with editing DateTime fields when data type mapping from string to DateTime is used is fixed
  • Bug with refreshing record if the key field has the TSQLTimeStamp data type is fixed

New in Oracle Data Access Components 9.4.12 (Oct 1, 2014)

  • Migration from DOA is added
  • ConnectionTimeout is now used on OSX and Mobile platforms
  • Bug with AV on OCI Pooling usage is fixed
  • Bug with auto-generated parameter types is fixed
  • Bug with detecting Object types as XML types in data type mapping is fixed
  • Bug with AV on an attempt to access server after connection loss is fixed
  • Bug with RecNo in the UniDirectional mode is fixed
  • Bug with setting SQL query when ParamCheck = False is fixed
  • Bug with AV failure on getting metadata by TCustomDADataSet is fixed
  • Bug with AV failure under Mobile when DacFMX is used is fixed

New in Oracle Data Access Components 9.4.11 (Sep 26, 2014)

  • 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 TCustomDAConnection.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
  • Several bugs in the SmartFetch mode are fixed
  • Bug with alternative quoting is fixed
  • Bug with getting the multi-pipe message is fixed
  • Bug with Blob in the disconnected mode is fixed
  • Bug with releasing TOraType after disconnect is fixed
  • Bug with EXEC and EXECUTE clauses in TOraScript is fixed
  • Bug with non-cutting fixed strings in TOraObject is fixed
  • Bug with detecting CharLength after AssignSvcCtx is fixed
  • Bug with AV on raising an Oracle error in the Trial edition is fixed
  • Bug with AV on application closing if connection was established in the OCI7 mode is fixed
  • Bug with quoting names in the EmptyTable method is fixed
  • Bug with calling the Refresh method after executing the EmptyTable method is fixed
  • Bug with setting calculated field values using the AsExtened property is fixed
  • Bug with re-calling the AfterExecute event is fixed
  • Bug with re-calling the BeforeExecute event is fixed

New in Oracle Data Access Components 9.3.10 (Aug 1, 2014)

  • Data type mapping from RAW(16) to ftGuid is added
  • Support for the Upper and Lower statements in TDADataSet.Filter is added
  • Support for the ftOraTimeStamp type in TVirtualTable is added
  • Bug with connection establishing if the client has negative half-hour time zone is fixed
  • Bug with displaying Time and DateTime parameter types in OraSQlMonitor is fixed
  • Bug with transactions in the OCI7 mode is fixed
  • Bug with tnsnames.ora parsing is fixed
  • Bug with parameters binding on Stored Procedures execution when Options.ProcNamedParams=True is fixed
  • Bug with parsing table names a if sub-query contains a WITH keyword is fixed
  • Bug with reopening TDADataSet after BreakExec is fixed
  • Bug with processing calculated and lookup fields in the SmartFetch mode is fixed
  • Bug with getting RecordCount when QueryRecordCount is True is fixed
  • Bug with AV failure on opening TCustomDADataSet when Range was set is fixed
  • Bug with "Invalid field size" in TVirtualTable is fixed
  • Bug with AV failure on freeing objects on mobile platforms is fixed
  • Several bugs in the SmartFetch mode are fixed

New in Oracle Data Access Components 9.3.9 (May 28, 2014)

  • Named parameters on generating procedure call are supported
  • The AssignLDA method is added for assigning LDA to TOraSession
  • Bug with compilation in C++Builder is fixed
  • Bug with invalid behavior in multithreaded applications is fixed
  • Bug with getting date attributes from inherited object data types is fixed
  • Bug with AV on appending a record with BLOB if DataSet was reopened is fixed
  • Bug with SQL query for indexes retrieving is fixed
  • Bug with instant client is fixed
  • Bug with setting boolean parameters in a non-English IDE at design-time is fixed
  • Bug with AV failure on fetching records in the UniDirectional mode is fixed
  • Bug with finding master parameters by original name on refreshing record when using master/detail relationship by parameters is fixed

New in Oracle Data Access Components 9.3.8 (Apr 30, 2014)

  • 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
  • The SetOrderBy method behavior is fixed
  • The GetOrderBy method behavior is fixed
  • Bug with detect parameters if a string constant contains ':' in the Direct mode is fixed
  • Bug with detecting table names in an SQL statement containing JOIN is fixed
  • Bug with raising Assert when parameters are used in TOraPackage is fixed
  • Bug when opening SmartQuery editor in Lazarus is fixed
  • Bug with Largint columns in OraLoader is fixed
  • Bug with result parameters is fixed
  • Bug with connection when UnicodeEnvironment=True in the Direct mode is fixed
  • Bug with displaying already installed DAC version in setup messages is fixed
  • Bug with Locate when a NULL value is present in the index field is fixed
  • Bug with IndexFieldNames when DataTypeMapping is enabled is fixed
  • Bug with the Filter behavior in the Metadata component is fixed
  • Bug with AV on modify table with one only Object field is fixed
  • Bug with freeing memory in the TDADataSet.Lookup method is fixed
  • Bug with error processing on socket data reading under Unix is fixed

New in Oracle Data Access Components 9.2.7 (Feb 26, 2014)

  • Now OraNet.obj and OraNet.o files are supplied for C++Builder
  • Bug on connection establishing using Oracle 8, 9, 10.1 clients is fixed

New in Oracle Data Access Components 9.2.6 (Feb 20, 2014)

  • Returning SQL Command Code for CREATE TABLE & DROP TABLE in the Direct Mode is added
  • Possibility to use MAS_ prefix for parameters when using master/detail relationship is added
  • Bug with setting the UnicodeEnvironment option is fixed
  • Bug when the Inited property of TOracleHome is not set to True for Oracle Instant Client is fixed
  • Bug with AV on release Environment reference in TOraNumber.Destroy is fixed
  • Bug with connection to Oracle on Unix platforms is fixed
  • Bug with AV on prepared Stored Procedure execution is fixed
  • Bug with AV on getting Cursor from prepared Stored Procedure execution is fixed
  • Bug with the ORA-24344 error message format in the Direct mode is fixed
  • Bug with AV on reconnection for Mobile platforms is fixed
  • Bug with AutoCommit in ExecSQL and ExecSQLEx for TOraSession is fixed
  • Bug with post data when LockMode=lmOptimistic and Data Type Mapping is applied is fixed
  • Bug with opening dataset when persistent fields were created in dataset is fixed
  • Bug with parameter name quoting on assigning field value to parameter is fixed
  • Bug with deleting a record inserted earlier in CachedUpdates mode is fixed
  • Bug with generating SQL queries by "SQL Generator" in design-time is fixed
  • Bug on sorting BLOB fields is fixed

New in Oracle Data Access Components 9.2.5 (Dec 28, 2013)

  • 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
  • Bug with Password which length is exactly 16 characters for Oracle 11.0.2.4 in the Direct mode is fixed
  • Bug with DB object names containing the '$' and '#' characters is fixed
  • Bug with Memory Leak in the NonBlocking mode is fixed
  • Bug with parameters when they are created in a custom order in TOraStoredProc is fixed
  • Bug with data loss when updating records in the CachedUpdates mode is fixed
  • Bug with connecting in the Direct mode under Windows 2000 and lower is fixed
  • Bug with data display in Detail Dataset when master field is Null is fixed
  • Bug with mapping to BCD fields when using TClientDataSet is fixed
  • Bug with incorrect parameter sizes when re-opening a query is fixed
  • Bug with RefreshRecord in the CachedUpdates mode is fixed
  • Bug with mapping single types to float types is fixed
  • Bug with mapping to BCD and FmtBCD types is fixed
  • Bug with filtering boolean fields is fixed
  • Bug with freeing complex fields after refreshing before editing is fixed
  • Bug with Locate by fields where Data Type Mapping is applied is fixed
  • Bug with RefreshQuick when IndexFieldNames is set is fixed

New in Oracle Data Access Components 9.1.4 (Sep 26, 2013)

  • Critical bug with parsing unicode SQL queries is fixed

New in Oracle Data Access Components 9.1.3 (Sep 20, 2013)

  • RAD Studio XE5 is supported
  • Android in RAD Studio XE5 is supported
  • Performance is improved
  • Automatic checking for new versions is added
  • Flexible management of conditions in the WHERE clause 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
  • Bug with Memory Leak in the Direct Mode is fixed
  • Bug with an empty error message for ORA-24344 in TOraDataSet is fixed
  • Bug with retrieving KeyFields when using Data Base Link is fixed
  • Bug with getting TimeStamp & Interval fields when FieldsAsString=True is fixed
  • Bug with getting a parameter with the Currency data type is fixed
  • Bug with TOraAlerter for iOS is fixed
  • Bug with storing the dbMonitor active state to DFM is fixed
  • Bug with setting ConnectionTimeout for Unix, Mac OS and iOS platforms is fixed
  • Bug with incorrect displaying of long names of parameters and macros in design-time is fixed
  • Bug with moving data from WideMemo to String fields by CRBatchMove is fixed
  • Bug with showing a connection dialog in design-time when LoginPrompt is set to False is fixed
  • Bug with setting the connection string containing inline comments is fixed
  • Bug with unnecessary unlock calling after an update error is fixed
  • Bug with processing cached data when UpdateRecordTypes is not default is fixed
  • Bug with TCRBatchMove and DataSets in the UniDirectional mode is fixed
  • Bug in TCRBatchMove when destination dataset has no key fields is fixed
  • Bug in TOraLoader with data loading from Dataset when the FetchAll option is set to False is fixed

New in Oracle Data Access Components 9.0.2 (Jul 16, 2013)

  • Oracle 12c is supported
  • Connection dialog is improved
  • Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
  • Bug with getting error message on object compilation in Oracle client versions lower than 11 is fixed
  • Bug with size of NVARCHAR2 columns in the SELECT query in the Direct mode is fixed
  • Bug with object and table types in the scrollable cursors is fixed
  • Bug with not freeing memory allocated for array parameters on calling the Clear method is fixed
  • Bug with TIMESTAMP parameters of stored procedures in the direct mode is fixed
  • Bug in the alerter when DisconnectedMode is set to True for a connection is fixed
  • Bug with the connection OnLogin event is fixed
  • Bug with incorrect counting of connections in pool is fixed
  • Bug with time fields in Lazarus is fixed
  • Bug with varbinary fields in Lazarus is fixed
  • Bug with using case-insensitive filter is fixed
  • Bug with getting and setting the SQL property of FastReport datasets is fixed
  • Bug with positioning of Fields Editor is fixed
  • Bug with not using index fields on locating records is fixed
  • Bug with processing the cached data when UpdateRecordTypes is not default is fixed
  • Bug with processing persistent fields in TVirtualTable is fixed

New in Oracle Data Access Components 9.0.1 (May 20, 2013)

  • Rad Studio XE4 is supported
  • NEXTGEN compiler is supported
  • Application development for iOS is supported
  • BINARY_DOUBLE & BINARY_FLOAT data types support in the Direct mode is added
  • Connection string supis improved
  • Possibility to encrypt entire tables and datasets is added
  • Possibility to determine if data in a field is encrypted is added
  • Support of TimeStamp, Single and Extended fields in VirtualTable is added
  • Bug with raising internal "Net Error 1" on reading Lob data types for some encodings in the Direct mode is fixed
  • Bug with incorrect detecting constant values length in SELECT expression for UTF8 databases in the Direct mode is fixed
  • Bug with application hang on get NVarchar column through link to MS SQL Server in the Direct mode is fixed
  • Bug with inserting NVARCHAR data for UTF8 databases and Oracle 10 or below if INSERT statement contains RETURNING section is fixed
  • Bug with application hang in non-blocking mode is fixed
  • Bug with Master-Detail for TClientDataSet in Rad Studio XE3 is fixed
  • Bug with Master-Detail by non-English fields is fixed
  • Bug with IndexFieldNames by non-English fields is fixed
  • Bug with incorrect RecordCount result when a query contains both ORDER BY and LIMIT is fixed
  • Bug with calling Cancel in the BeforePost event is fixed
  • Bug when setting the TDataSet.Filter property for empty dataset is fixed
  • Bug with incorrect TVirtualTable version displaying in the About box is fixed
  • Thread handle leak when using pooling is fixed
  • Now the TCustomDASQLMonitor.Options.moDBMonitor property is set to False by default

New in Oracle Data Access Components 8.6.12 (Feb 15, 2013)

  • Rad Studio XE3 Update 2 is now required
  • Bug with record updating when table is blocked in the lmLockImmediate mode is fixed
  • Bug with detecting the scale of the INTERVAL DAY TO SECOND data type is fixed
  • Bug with memory leak in Master-Detail datasets that contain TOraLob fileds is fixed
  • Bug when setting the CheckMode property to cmRefresh is fixed
  • Bug with storing the BINARY_FLOAT data inside any Object type is fixed
  • Bug with AV on adding TFieldDef items to FieldDefs for Delphi 2009 and higher is fixed
  • Bug with incorrect detection of the numeric parameter type in ExecSQL is fixed
  • Bug with assigning data to blob fields when using Data Type Mapping is fixed
  • Bug with inserting a new record into TStringGrid in FMX is fixed
  • Bug with unlocking a record after constraint violation is fixed
  • Bug with quoting index field names in TCRDBGrid is fixed
  • Bug with Master-Detail link by fields with non-English names is fixed
  • Bug with saving Date fields in XML is fixed

New in Oracle Data Access Components 8.6.11 (Dec 18, 2012)

  • Rad Studio XE3 Update 1 is now required
  • C++Builder 64-bit for Windows is supported
  • Bug with compatibility with MyDAC is fixed
  • Bug with getting data with CHAR type for Oracle 7 is fixed
  • Bug with setting Charset property for Oracle client 9 & 10 is fixed
  • Bug with AV in ApplyUpdates method in OraDataSet with not defined Session property is fixed
  • Bug with impossibility to edit query if it contains '(' inside quotes is fixed
  • Bug with application hanging with TOraAlerter on connection loss is fixed
  • Bug with Filter and CHAR data type when UseUnicode=True is fixed
  • Bug with format of TIMESTAMP(0) field is fixed
  • Bug with using quoted field names in the IndexFieldNames property is fixed
  • Bug with processing macros named in Cyrillic is fixed
  • Bug in TOraStoredProc with closing dataset when the Disconnected property is True is fixed

New in Oracle Data Access Components 8.5.10 (Nov 7, 2012)

  • Some improvements for NEXTGEN support are added
  • Support for ftGraphic and ftFmtMemo parameter data types is added
  • Informativity of messages about errors in connection is improved
  • Dependency of design-time packages on FMX packages is removed
  • Limitation on maximum 10 Oracle Homes is removed
  • Bug with parameter length for UTF8 databases is fixed
  • Bug with parameter length loaded from DFM is fixed
  • Bug with TIMESTAMP fields in TOraLoader is fixed
  • Bug with LargeInt calculated fields is fixed
  • Bug with refresh cursor with AutoClose=True is fixed
  • Bug with LOB fields for Oracle 8.0.5 is fixed
  • Bug with data loss in pessimistic lock mode is fixed
  • Bug with AV failure in RefreshQuick method is fixed
  • Bug with renaming of fields with the same names is fixed
  • Bug with dependency parameters count in macros on delimeter is fixed
  • Bug with storing the LoginPrompt connection property is fixed
  • Bug with creating columns on setting the TableName property in TDALoader is fixed

New in Oracle Data Access Components 8.5.9 (Sep 10, 2012)

  • Rad Studio XE3 is supported
  • Windows 8 is supported
  • Bug with storing empty MapRules collection in DFM is fixed
  • Bug with getting Raw as String is fixed
  • Bug with describing stored procedure parameters from a package in the Direct mode is fixed
  • Bug with AV at releasing temporary Lobs is fixed

New in Oracle Data Access Components 8.2.8 (Jul 27, 2012)

  • Support for the TOraTimeStamp format is improved
  • Bug with the ftCurrency, ftDate, ftTime parameter types is fixed
  • Bug with detecting Oracle client version is fixed
  • Bug with not resetting a statement index in OraScript after an error is fixed
  • Bug with retrieving TOraObject that contains BLOB or CLOB after calling a constructor is fixed
  • Bug with Data Type Mapping and persistent fields is fixed
  • Bug with Data Type Mapping to Bytes and VarBytes is fixed
  • Bug with decryption of binary fields is fixed
  • Bug with editing calculated fields is fixed
  • Connection dialog is now open in the screen center instead of the desktop center
  • Several bugs with compilation on Delphi XE2 from Source code are fixed

New in Oracle Data Access Components 8.2.7 (Jun 24, 2012)

  • Update 4 Hotfix 1 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
  • Integration with dbForge Studio for Oracle is added
  • 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
  • FieldType ftOraTimeStamp is added
  • Field types were renamed: ftTimeStampTZ -> ftOraTimeStampTZ, ftTimeStampLTZ -> ftOraTimeStampLTZ
  • Bug with EnableOraTimeStamp=False in TOraSession is fixed
  • Bug with connection to Oracle XE with the UTF8 charset is fixed
  • Bug with auto-generated queries for tables with case-sensitive fields in the Direct mode is fixed
  • Bug with Connection Mode set for a connection that is established from OraScript is fixed
  • Bug with statements count when a script contains the "Connect" command is fixed
  • Bug with loading Unicode strings by TOraLoader is fixed
  • Bug with quoted Object type names is fixed
  • Bug with executing a script that ends with a commented line is fixed
  • Bug with assigning outsize data to TWideStringField is fixed
  • Bug with AV failure at calling the SetRecNo method when using local sorting is fixed
  • Bug in design time editor of the TVirtualTable component with master-detail relationship is fixed

New in Oracle Data Access Components 8.1.6 (Apr 4, 2012)

  • Lazarus 0.9.30.4 and FPC 2.6.0 are supported
  • Bug with SQL Generator in the design-time is fixed
  • Bug with generating Update SQL with fields that have aliases is fixed
  • Bug with filling fileds with Unicode names from Sequences in the Direct mode is fixed
  • Bug with memory leak in TOraObject is fixed
  • Bug with saving BCD fields from Virtual table to a Stream is fixed
  • Bug with LocalMasterDetail is fixed

New in Oracle Data Access Components 8.1.4 (Dec 29, 2011)

  • The UniqueFieldIndexSeparator global variable is added
  • Bug with memory leak and non-existing stored procedure in the Direct mode is fixed
  • Bug with '(' and ')' application name in the Direct mode is fixed
  • Bug with assertion failure at proccesing the cached data is fixed
  • Bug with Delphi IDE hanging at closing in case of using DBMonitor is fixed
  • Bug with freeing memory in Lazarus is fixed
  • Bug with executing the queries with parameters in Delphi 5 is fixed
  • Several bugs with 64-bit application development are fixed
  • Several bugs in design-time editors are fixed

New in Oracle Data Access Components 8.1.3 (Dec 29, 2011)

  • Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
  • Mac OS X 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 11g Express Edition is supported
  • The QueryResultOnly option is added to TOraChangeNotification
  • Conflict with size_t data type in C++Builder is resolved
  • Bug with invalid password in the Direct mode for Windows 98 is fixed
  • Bug with reading long ORACLE_HOME line from the registry is fixed.
  • Bug with updating DatSet when LongStrings=False is fixed
  • Bug with posting nested objects of the not final type is fixed
  • Bug with memory leak in TDALoader is fixed
  • Problem with receiving DateTime parameter for DBMonitor in Delphi 2009 and higher is fixed

New in Oracle Data Access Components 8.0.2 (Dec 29, 2011)

  • Bug with compilation for Linux in Lazarus is fixed
  • Bug with multi-dimension arrays is fixed
  • Bug with getting attributes of inherited object types is fixed
  • Bug with huge memory allocating on Lobs uploading by OraLoader is fixed
  • Bug with Lob parameters in the Direct mode if ParamType=ptUnknown is fixed

New in Oracle Data Access Components 8.0.1 (Dec 29, 2011)

  • 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
  • Bug with LOB parameters is fixed
  • Bug with OraLoader for Number(1,0) data type is fixed
  • Bug with Int64 data type for OraLoader is fixed
  • Bug with filling default values for inactive DataSet in design-time is fixed

New in Oracle Data Access Components 7.20.0.8 (Dec 29, 2011)

  • Bug with several connections and when OCIUnicode=True is fixed
  • Bug with multiple LocalTransactionID getting is fixed
  • Bug with creating quoted fields in the design time is fixed
  • Bug with assertion failure on using master/detail relationship with TClientDataset is fixed
  • Bug in TCustomDADataSet.PSGetKeyFields method when persistent fields are created in dataset is fixed

New in Oracle Data Access Components 7.20.0.7 (Jul 7, 2011)

  • Possibility to load data in TVirtualTable without recreating persistent fields is added
  • Working in design time editor of the TVirtualTable component is improved
  • Loading files opened by other applications is improved
  • Support of case sensitive procedures and packages is improved
  • Support of overload procedures is improved
  • Bug with invalid PL\SQL compilation error raising is fixed
  • Bug with change password in the direct mode is fixed
  • Bug with free temporary LOBs as out params at the server is fixed
  • Bug with inserting empty strings in DML arrays is fixed
  • Bug with refreshing detail Dataset twice if master Dataset is empty is fixed
  • Bug with WideString params in Oracle 8.0.5 or lower is fixed
  • Bug with processing key fields on record posting is fixed
  • Several bugs with design-time editors for Lazarus are fixed

New in Oracle Data Access Components 7.20.0.6 (May 5, 2011)

  • 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
  • Bug with 'SQL statement doesn't return rows' error if previous statement execution failed is fixed.
  • Bug with invalid update query for Blob fields if the roBeforeEdit option is set is fixed
  • Bug with preparing SQL statements that contain empty table parameters is fixed
  • Bug with error notification on invalid PL/SQL compilation in the Direct mode is fixed
  • Bug in bookmark validity check is fixed

New in Oracle Data Access Components 7.10.0.5 (May 5, 2011)

  • Delphi & C++Builder XE Starter Edition supported
  • added case-sensitivity schema names support
  • Fixed registration procedure of Borland SQL Monitor when TUniSQLMonitor is created at runtime

New in Oracle Data Access Components 7.10.0.4 (Feb 10, 2011)

  • Added support for connection with using Service Name in the Direct mode.
  • Improved returning cursors with different fields list from TOraStoredProc
  • Fixed Clob parameters reading and writing for charsets with varying character width
  • Fixed search for the TNS_ADMIN variable in the Oracle root location in the registry.
  • Fixed the GetOrderBy method
  • Fixed moving data with the OraNumber data type by the TCRBatchMove component

New in Oracle Data Access Components 7.00.0.3 (Feb 10, 2011)

  • Added support for the ChangePassword functionality in the Direct mode
  • Added calling the BeforeExecute event for the Open and Refresh dataset operations.
  • Fixed bug when user's value was overridden by the sequence value in the smPost sequence mode
  • Fixed the Detail dataset refreshing (for Master-Detail datasets) after connection loss in the LocalFailover mode
  • Fixed bug with refreshing record for Master-Detail datasets

New in Oracle Data Access Components 7.00.0.2 (Feb 10, 2011)

  • Added search for the TNS_ADMIN variable in the Oracle root location in the registry
  • Added checking that dataset is open on calling the TDataSet.Locate method
  • Fixed bug with multi-thread applications
  • Fixed bug with fetching data in the Direct mode
  • Fixed bug with selecting Unique Key instead of Primary Key as a Key field for TOraQuery or TSmartQuery
  • Fixed bug with connection to Oracle 8.0.5 in the Direct mode
  • Fixed bug with updating NVARCHAR fields in the Direct mode with OCIUnicode=true
  • Fixed bug with Unicode in the Direct mode for Delphi 5
  • Fixed bug "out of range" with the GetTickCount function on continuous working

New in Oracle Data Access Components 7.00.0.1 (Feb 10, 2011)

  • Embarcadero RAD Studio XE suppored
  • Fixed bug with AL32UTF8 and ZHS16GBK encoding in the OCI and Direct modes. Now field size and strings storing in these encodings is correct.
  • Fixed bug with update or insert in the Batch mode with custom (user defined) INSERT or UPDATE queries.
  • Fixed bug when ODAC truncates silently string parameters with length more then 4000 characters. Now it raises an error.
  • Fixed bug with displaying TimeStamp format if user changes Regional Settings when application is running. Now the TimeStamp format depends on ShortDateFormat and LongTimeFormat Delphi global variables.
  • Fixed bug with TOraTable with filling the KeyFields property. Now the KeyFields published property can be be filled by user only.
  • Fixed bug with filling default expression for fields in the design mode for inactive dataset
  • Fixed bug with the LIKE keyword in the TDataSet.Filter property

New in Oracle Data Access Components 6.90.0.60 (Feb 10, 2011)

  • Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
  • Added the OnBeforeExecute event
  • Fixed bug with getting warning message for the Direct mode
  • Fixed bug with assigning connection to DLL for the Direct mode
  • Fixed the SaveToStream and LoadFromStream methods of TOraXML, now #0 is not added in the end of the stream
  • Fixed bug with inserting records with CLOB fields in the Direct mode for Oracle 10
  • Fixed bug with RefreshRecord and numbers with floating point
  • Fixed bug in Migration Wizard with converting units in the UTF8 and UTF16 encoding

New in Oracle Data Access Components 6.90.0.59 (Feb 10, 2011)

  • Added ability to lock records in the CachedUpdate mode
  • Added overloaded declaration of the ApplyUpdates method to choose update kind
  • Fixed bug with quote that first character inside quoted string for the Filter property
  • Fixed bug in TCRBatchMove with processing RecordCount
  • Fixed bug with representation the TIMESTAMP WITH LOCAL TIME ZONE data type
  • Fixed bug with get IN/OUT parameters if it returns NULL
  • Fixed bug with return compilation error on compilation a database object from other schema

New in Oracle Data Access Components 6.90.0.58 (Feb 10, 2011)

  • Fixed bug with changing password with inactive connection
  • Fixed bug with AV on setting item of array with the DATE data type
  • Fixed bug with AV on changing value of array with type varray(32767) of varchar2(32767) in the Unicode mode
  • Fixed bug with memory leak on Oracle server on TOraBlob.FreeTemporary in the Direct mode
  • Updated Oracle client version detection for Linux by OCI API

New in Oracle Data Access Components 6.90.0.57 (Feb 10, 2011)

  • Bug with comparing Date field values on optimistic locking fixed
  • Bug in the AddWhere, DeleteWhere, SetOrderBy, and GetOrderBy methods for Tables fixed
  • Bug with calculating RecNo in CachedUpdates mode fixed
  • Memory leak with executing prepared statements fixed
  • Bug with unicode parameters on Delphi 2009 and 2010 in the Direct mode fixed
  • Bug with getting metadata on Oracle 8.0.5 fixed
  • Bug with getting UDTs metadata fixed
  • Bug with XMLType parameters in TOraStoredProc fixed

New in Oracle Data Access Components 6.90.0.56 (Feb 10, 2011)

  • Added support of National parameter to Package Wizard
  • Added ability to send call stack information to the dbMonitor component
  • Bug with the Savepoint method fixed
  • Bug AV on assigning the TOraNestTable.ItemAsString property fixed
  • Bug AV when inserting blob field using TClientDataset fixed
  • Bug with refreshing record when using master/detail relationship fixed
  • Bug with LocalUpdate in the CachedUpdates mode fixed
  • Bug with DBMonitor for C++ Builder 6 fixed

New in Oracle Data Access Components 6.90.0.55 (Feb 10, 2011)

  • Added OnStart, OnCommit, OnRollback events to TDATransaction
  • Added OnInfoMessage event
  • Problem with using TLargeintField in master/detail fixed
  • Bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmPessimistic fixed
  • Several bugs with Direct mode fixed

New in Oracle Data Access Components 6.90.0.54 (Dec 8, 2009)

  • Added support for dbMonitor 3
  • Bug with updating table, that has field name, representing a valid hexadecimal number, fixed
  • Bug with updating field value with preceding spaces when TrimFixedChar or TrimVarChar = True fixed
  • Bug with executing large file in UTF-8 format fixed
  • Bug with mapping ROWID on ftString in Direct mode when UseUnicode=True fixed

New in Oracle Data Access Components 6.90.0.53 (Dec 8, 2009)

  • Now Required flag is set for UpdatingTable fields only
  • Bug with detecting parameter size for MBCS strings fixed
  • Problem with detecting slash with text after it as a delimiter in TDAScript fixed
  • Bug with SetOrderBy and SetWhere when there is no space before ORDER or WHERE fixed
  • Bug with executing large file in Unicode format fixed
  • Problem with OraQueryCompatibilityMode fixed
  • Bug with ftWideString parameters in Direct mode when UseUnicode=False fixed

New in Oracle Data Access Components 6.90.0.52 (Dec 8, 2009)

  • Added support for using user-defined UpdatingTable when ODAC cannot detect a table list for a query
  • Now the AssignConnect method copies transaction state
  • Bug with locating records using the LocateEx method and the lxNearest option fixed
  • Bug with AV failure in MemData fixed
  • Bug with OCI Unicode environment and non-Unicode CLOBs fixed
  • Bug with writing BLOBs in Direct mode with OCI Unicode environment fixed
  • Bug with SQL Generator in design-time fixed
  • Problem with help registration under RAD Studio 2010 fixed
  • Problem with loading DataSet Manager under RAD Studio 2010 fixed

New in Oracle Data Access Components 6.90.0.51 (Sep 30, 2009)

  • Embarcadero RAD Studio 2010 suppored
  • Now the subdetail is refreshed before the AfterRefresh event of the detail is called

New in Oracle Data Access Components 6.80 (Apr 8, 2009)

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

New in Oracle Data Access Components 6.70 (Nov 11, 2008)

  • 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 in Oracle Data Access Components 6.20 (Nov 15, 2007)

  • CodeGear RAD Studio 2007 and C Builder supported
  • Added abilities to customize whether update SQL statements should be prepared and setting number of rows to be prefetched by OCI
  • Added the OnProgress event in TOraLoader
  • Added Oracle Package Wizard that simplifies working with PL/SQL Packages