history
July 7, 2007 - Version 4.1.0.0 releasedThis new version adds Unicode compatibility. It supports UTF-8 and UTF-16 encoded character data for queries, datasets, objects, and CLOB's. UTF-8 data can be accessed as AnsiString data as usual through the various properties and methods. For UTF-16 data various new WideString properties and methods have been added. See the 4.1 Documentation Addendum for details.
June 1, 2007 - Delphi 2007 version released A Delphi 2007 version is released.
January 21, 2006 - Delphi 2006 version released A Delphi 2006 version is released with the following restrictions
* Win32 only, no support yet for .NET and C#. * There is no integrated help. The help file is provided in the old format.
October 17, 2005 - Improvements in version 4.0.7.1 Bugfixes
* TOracleObject.Free could cause invalid handle exception
October 3, 2005 - Improvements in version 4.0.7 Enhancements and bugfixes
* Support for Oracle10g binary_float and binary_double added * Global LogActivity hook added to allow logging and timing of all database activities (see LogActivity.doc) * Calling an Instant Client application from an Instant Client application would fail * Property editors, Oracle menu, and Query Buider now work in Delphi 2005 (requires new Query Builder 1.2) * Null CLOB's would always be inserted as empty_clob() for Delphi 5 and later * TOracleScript now supports create or replace Java * Fixed QBE issue with complex conditions * Fixed TOracleQuery.Describe performance issue on 8.x clients * TOracleQueue instances could not be reused after reconnecting a session
November 29, 2004 - Delphi 2005 version released A Delphi 2005 version is released with the following restrictions
* Win32 only, no support yet for .NET and C# * There is no integrated help. The help file is provided in the old format * There is no Oracle menu in the IDE * The Package Wizard is not available
September 1, 2004 - Improvements in version 4.0.6.2 Bugfixes
* TOracleClientDataSet.FetchParams could cause "Parameter <name> not found" exception for Delphi / C++Builder 5 and later
August 23, 2004 - Improvements in version 4.0.6.1 Bugfixes
* Connecting through SQL*Net 2 could fail
August 18, 2004 - Improvements in version 4.0.6 Enhancements
* Support for Oracle10g Instant Client added * Support for Oracle10g EZCONNECT added * TOracleSessionPool.AfterConnect event added * Property TOracleDataSet.OracleDictionary.CharacterSize added * TOracleSession.InTransaction optimized (Oracle.OptimizeInTransaction can be set to False to fall back to previous unoptimized mode)
Bugfixes
* TOracleDataSet.Locate could not search for fields with only spaces if TOracleSession.Preferences.TrimStringFields = False * TOracleDataSet Detail variables are now declared as CHAR when master field is a CHAR to prevent trailing space issues * Dataset and Navigator components were disable in Property Defaults Editor * Provider Support function PSGetParams could raise "Parameter <name> not found" exception in IDE * UseSingleEnvironment optimization removed due to stability issues * Could not connect with usernames with special characters such as '-' and '.' * Fetching temporary LOB's in a query or dataset would result in resource leaks * Hints are preserved for TOracleDataSet.CountQueryHits * Accessing a timestamp field or variable as TDateTime could cause a conversion error for milliseconds > 999.5
April 1, 2004 - Improvements in version 4.0.5 Bugfixes
* Oracle Home detection did not work correctly for Oracle10g client * Setting TOracleSession.OptimizerGoal to anything but ogUnchanged would cause ORA-01986 on Oracle10g * QBE would not handle IN(...) properly for string fields * QBE mode did not set size for TDBEdit's * Improved PL/SQL Developer (version 5.1.6) interface
February 16, 2004 - Improvements in version 4.0.4 Enhancements
* StripDefaultDomain global variable added. When enabled, the default domain from sqlnet.ora (names.default_domain) will be stripped from aliases * TOracleQueue.MessageProperties.RecipientList added * Support added for temporary LOB's for transient object instances * QBE now supports Soundex function and 'sounds like' operator (e.g. sounds like smith) * Added FailedLogonCount to OracleLogon unit to keep count of failed logon attempts * Oracle Monitor 2.1 released, with new logging and tray icon functionality
Bugfixes
* After entering/leaving QBE mode in a master dataset, the primary key fields could be read-only * OracleCI.OCIVersion now returns correct value for OCI 9.0 and 9.2 * TOracleSession would incorrectly fall back to OCI7 mode on Oracle10g * Updating/Inserting object fields could cause ORA-00900 error * TOracleQueue.Dequeue would cause ORA-01036 if DequeueOptions.ConsumerName is specified * Connection failures for a pooled session would cause an access violation * Fixed a QBE bug that would not allow operators and would not display string fields when a Dataset has QBEMode set at design time * Number columns without scale and precision would be reported with a scale of -127 on 9.2.0.4 and later
December 1, 2003 - Improvements in version 4.0.3 Bugfixes
* Editing a dataset with a BLOB could cause erroneous "Record changed by another user" message * Fixed possible access violation when closing a TOracleQuery
November 2003 - Improvements in version 4.0.2 Bugfixes
* QBE improvement: support null value and other values (e.g. smith or null) * Substitution variables were not multi-byte compliant for all character sets * Memo fields in a 3 tier application with TDataSetProvider.ResolveToDataSet = True could cause erroneous "Record changed by another user" message * Refreshing a BLOB or LONG RAW would cause a "stream read error" * Password expiration did not handle ORA-28011 (The account will expire soon; change your password now) * Direct Path Loader could cause ORA-03113 on Oracle Net 8.1 * SetPassword Dialog would not clear password edit controls * Primary key fields could be omitted from insert through TDataSetProvider for detail datasets
October 2003 - Improvements in version 4.0.1 Bugfixes
* QBE Fixes: o Could not query on number fields without an operator (ORA-00936) o "is not null" expression is now supported o Ignore Time option could cause ORA-01858 o QBE Definition Editor could raise "Field <name> not found" if not all fields are persistent * TOracleSessionPool with Max > 0 could cause hang-up * Substitution variables were not multi-byte compliant * TOracleScript had a problem with subsequent PL/SQL blocks
October 2003 - Improvements in version 4.0.0 New components and objects
* TOracleQueue component added for dbms_aq support * TOracleSessionPool component added for session pooling * TOracleTimestamp object added for timestamp support * TXMLType object added for XMLTYPE support
TOracleDataSet enhancements
* Supports Object fields * Supports Collections (nested table and varray) as detail datasets * Supports Timestamp fields as TDateTimeField * Supports XMLType fields as TMemoField * QBE now supports operators: >, <, !="," not, like, between, in * UniDirectional property added * Support for Index Organized Tables (IOT) added * CompressBLOBs property added for BLOB compression * CompressionFactor runtime property added * OnCompressBLOB and OnDecompressBLOB events added for custom compression * Detachable property added to retain result set when session disconnects * RefreshRecord now also refreshes CLOB, BLOB, BFILE, Long and Long Raw fields * DeclareAndSet procedure added to declare and set a variable in one call * If Optimize = False or Session.StatementCache = True, cursors are implicitly closed whenever possible
TOracleQuery enhancements
* Supports Timestamp fields and variables as TOracleTimeStamp * Supports XMLType fields and variables as TXMLType * Scrollable query support added (requires Oracle9 + oracle bug fixes) * FieldAsString now supports CLOB, BLOB, BFILE, Long and Long Raw and Reference data types * DeclareAndSet procedure added to declare and set a variable in one call * If Optimize = False or Session.StatementCache = True, cursors are implicitly closed whenever possible
Provider Support improvements
* TOracleDataSet.ProviderOptions added * Records applied through a TDataSetPrivider with ResolveToDataSet = False now also use the MessageTable
TOracleSession enhancements
* StatementCache and StatementCacheSize added for 9.2 statement caching * Pool property added to assign the session to a specific pool * Preferences.NullObjectIsEmpty added * Preferences.TemporaryLOB added * Preferences.TimestampAsString added
TOracleSessionPool enhancements
* Is now a component * Min, Max and TimeOut properties added for tuning purposes * CompressOld procedure added to remove idle sessions * Homogeneous and Logon properties added * StatementCache added * PoolType property added for generic OCI 9.2 Pooling support * Sessions[] property added * Now checks connection when reserving an existing session from the pool
Temporary LOB support added
* TLOBLocator.CreateTemporary constructor added * TLOBLocator.Temporary property added
TOracleObject enhancements
* TimestampAttr added for Timestamp support * XMLAttr added for XMLTYPE support
TOracleLogon enhancemens
* Picture property added * Selecting an item with username/password from the history will immediately logon
TOracleScript enhacements
* Editor can now handle more than 64K text * ScanVariables property added to enable/disable variable substitution * ColWidth property added to control the maximum length of displayed columns * Added SET SCAN, FEEDBACK, ECHO, TERMOUT, EXITONERROR, COLWIDTH commands
Error handling enhancements
* EOracleError.Instance property added * EOracleError.Session property added * Global OnOracleError event handler added
Designtime enhancements
* Designtime Property Defaults tool added * SQL property Editor "Print with Variables" button added * Variables property Editor "Copy SetVariable call(s)" button added
Oracle Monitor enhancements
* Support for all Query Plan columns with corresponding preference * Step through Query Plan in order of execution * DisableMonitor and EnableMonitor function added to disable/enable the Oracle Monitor from within an application
New compiler directives (requires source option)
* NONVISUAL: removes all references to visual units for character based Linux servers * NODATASET: removes the dataset from the package to support Delphi/C++Builder Personal Edition