dbExpress Driver for Oracle History

8.1.0 15-Nov-23

Added support for RAD Studio 12
Added support for Oracle 23c
Added support for macOS Sonoma
Fixed string parameters bug for Oracle 11 and older
Fixed bug with "Range check error" error on describing FLOAT parameters in Stored Procedure

8.0.4 29-Mar-23

Added support for RAD Studio 11 Alexandria Release 3
Improved detection of home directories in recent versions of Oracle
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 the ftDateTime parameters

8.0.3 26-Sep-22

Added support for RAD Studio 11 Alexandria Release 2

8.0.2 10-Dec-21

Fixed bug with LONG parameters in Oracle 11 and earlier
Fixed bug with Access Violation when table name is not quoted

8.0.1 16-Sep-21

RAD Studio 11 Alexandria is supported
macOS ARM target platform is supported
Fixed bug with decimal digits getting truncated in parameters
Fixed bug with string OUT parameters in Oracle 12.1

7.3.1 14-Jul-21

Oracle 21c is supported
Data fetch performance in the Direct mode is improved

7.2.1 09-Jun-20

RAD Studio 10.4 Sydney is supported

7.1.2 28-Nov-19

Oracle 19c is supported
Now Trial edition for macOS and Linux is fully functional
Bug with scale for FLOAT data type is fixed

7.0.1 12-Aug-19

macOS 64-bit is supported
Linux 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

6.11.16 12-Dec-18

RAD Studio 10.3 Rio is supported
Oracle 18c is supported
OS authentication in the Direct mode is supported
Performance of data fetching in the Direct mode is improved
Performance of describing stored procedures in the Direct mode is improved

6.10.15 27-Apr-17

Driver compilation from source code is fixed

6.10.14 18-Apr-17

RAD Studio 10.2 Tokyo 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
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

6.9.13 26-Oct-16

Oracle Cloud (DBaaS) in the Direct mode is supported
Bug with connection via IPv6 protocol is fixed
Bug with incorrect field size is fixed

6.8.12 28-Apr-16

RAD Studio 10.1 Berlin is supported
Bug with connection to RAC server is fixed
Bug with not receiving the ORA-00028 error on session kill is fixed
Bug with the RequiredFields connection option is fixed

6.7.11 17-Feb-16

Bug with storing Blob data for Oracle 12c in the Direct mode is fixed
Bug with AV on calling TSQLDataSet.Close is fixed

6.7.10 10-Sep-15

RAD Studio 10 Seattle is supported
Now Trial for Win64 is a fully functional Standard Edition

6.6.9 17-Apr-15

RAD Studio XE8 is supported
Now the Direct mode is supplied as source code
Bug with TWideMemoField data size is fixed
Bug with AV in "SELECT NULL FROM ..." statements is fixed

6.5.8 19-Sep-14

RAD Studio XE7 is supported
Bug with connection establishing if the client has negative half-hour time zone is fixed

6.4.7 28-May-14

RAD Studio XE6 is supported

6.3.6 25-Feb-14

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

6.3.5 21-Feb-14

RAD Studio XE5 Update 2 is now required
Bug with mapping to BCD fields when using TClientDataSet is fixed

6.3.4 21-Oct-13

Rad Studio XE5 is supported
Oracle 12c is supported
Possibility to establish OCI and Direct connections in the same application is supported
IPv6 protocol support is added
Bug with object names containing the '$' character is fixed

6.2.3 16-May-13

Rad Studio XE4 is supported
Assembly registration without .NET SDK installed is improved
The 'Unexpected data type 25' error in Delphi 2007 is fixed
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

6.1.2 25-Dec-12

Rad Studio XE3 Update 1 is now required
C++Builder 64-bit for Windows is supported
Bug with Integer overflow is fixed
Bug with returning invalid values for OUT parameters is fixed
Bug with AV on returning OUT parameters is fixed

6.0.1 10-Sep-12

Rad Studio XE3 is supported
Windows 8 is supported
Data Explorer is supported
dbExpress 4 metadata is supported
Bug with connection to Oracle XE with UTF8 charset is fixed
Bug with DateTime params in Delphi 7 is fixed

5.1.3 20-Mar-12

Update 4 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Code improvements for avoiding compilation warnings

5.1.2 16-Dec-11

Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Mac OS X in RAD Studio XE2 is supported
Bug with Boolean stored procedure parameters is fixed
Bug with character ' in comments of PL/SQL blocks is fixed

5.0.1 15-Sep-11

Embarcadero RAD Studio XE2 is supported
Application development for 64-bit Windows is supported
FireMonkey application development platform is supported
Performance on getting indexes is improved
dclcrdbxXXX.dcp is added to installation
The RequiredFields option is added
Getting metadata for NUMBER data type is fixed

4.90.25 16-May-11

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
BINARY_FLOAT and BINARY_DOUBLE data types representation is improved (now it is TFloatField instead of TBCDField)
Bug with BCD representation for NUMBER data type is fixed (the UnknownNumberScale parameter specifies scale for NUMBER data type)
Bug with Unicode set to False for Delphi 2009 - Delphi XE is fixed
Bug with set RowSetSize in Delphi XE is fixed

4.80.24 03-Mar-11

Added support for connection with using Service Name in the Direct mode
Now the DBXERR_INVALIDUSRPASS error code is returned on connection establishing with invalid user name or password
Fixed bug with overflow in the TBCDField and TFMTBCDField fields by setting scale for the NUMBER data type

4.70.23 07-Dec-10

Improving performance on getting indexes information
Added the UnicodeAsNational connection parameter that allowed sending NVarchar parameters to the server correctly
Fixed bug with rollback transaction after failed commit

4.70.22 06-Oct-10

Embarcadero RAD Studio XE supported
Added the HomeName parameter for Delphi 2007 and higher
Fixed the SQLConnection.GetFieldNames method for numeric data types

4.50.21 01-Jul-10

Fixed bug with getting metadata for column with FLOAT data type

4.50.20 07-Dec-09

Added support for dbMonitor 3

4.50.19 09-Oct-09

Bug with fetching BLOB data for Delphi 2010 fixed

4.50.18 23-Sep-09

Embarcadero RAD Studio 2010 supported
Added UnicodeClobParams extended driver option that enables ftOraClob parameters with Unicode values
Several bugs related to using the driver with Datasnap componets fixed

4.40.16 11-Jun-09

Exception on disconnect caused by DBMonitor check, fixed
Access violation on getting Columns metadata fixed
Bug with no digits after decimal point in BCD fields under Delphi 2009 Update 4 fixed

4.40.15 30-Mar-09

Added the UseDateParams extended driver option that maps ftTimeStamp parameters to the Oracle DATE data type
Bug with not using IntegerPrecision and FloatPrecision options for parameters of TSQLStoredProc fixed

4.40.14 20-Jan-09

Added driver compiled with Delphi 2007 for using under Windows 98
Access violation with LOB parameters fixed

4.40.13 16-Oct-08

Added full Unicode support for RAD Studio 2009
Optimized LOB processing in Direct mode

4.40.12 04-Sep-08

Support for Delphi 2009 and C++Builder 2009 added

4.20.11 07-Aug-08

Bug with out parameters fixed

4.20.10 09-Jul-08

Bug with Direct mode connection fixed

4.20.9 03-Jul-08

Added support of the RowSetSize parameter under RAD Studio 2007
Bug with boolean fields under RAD Studio 2007 fixed
Bug with TIMESTAMP fields fixed
Bug with displaying BCD parameters in DBMonitor fixed
Bug with detecting record count on fetch fixed

4.20.8 07-Mar-08

Bug with infinite reconnect fixed
Access violation with multiple database connections from an application fixed
Bug with handling zero values in BCD and FmtBCD parameters fixed
Memory leak with BCD and FmtBCD parameters fixed

4.20.7 07-Feb-08

Bug with ftBCD, ftFmtBCD parameters and setting NLS_NUMERIC_CHARACTERS using ALTER SESSION fixed

4.20.6 12-Dec-07

Memory leak in the driver fixed
Added support for opening TSQLDataSet with DbxCommandType = DbxMetaData
Added the DbxOdaDriverLoader unit in DbxOda Source Code edition to enable embedding the driver into applications

4.20.5 29-Oct-07

Several bugs in installation fixed
Bug with boolean parameters fixed

4.20.4 10-Oct-07

CodeGear RAD Studio 2007 supported
Bug with losing parameters in TSQLStoredProc fixed

4.00.3 20-Aug-07

Bug with updating BLOB fields in Direct mode fixed
Bug with retrieving metadata in Delphi 2007 fixed

4.00.2 06-Jul-07

Complete support for dbExpress version 4 in Delphi 2007 for Win32 and C++Builder 2007 added
General performance improved

3.20.9 03-Apr-07

Added limited support for Delphi 2007 for Win32

3.10.8 22-Mar-07

Bug with access violation on connection loss fixed
Bug with access violation in multithreaded applications on Oracle 8 client fixed
Bug with truncation of CLOB values when using multibyte character set fixed
Bug with processing long field names in dbexpoda30.dll fixed

3.10.7 25-Dec-06

Removed workaround for dbExpress bug with Memo field value truncation (this bug is fixed in BDS 2006 Update 2)
Bug with driver installation fixed

3.10.6 13-Oct-06

Bug with processing FLOAT fields fixed

3.10.5 31-Aug-06

Added support for Turbo Delphi, Turbo Delphi for .NET and Turbo C++
Performance of fetching numeric types improved
Bug with executing stored procedures for Oracle Net driver fixed
Bug with string parameters for UTF-8 database fixed

3.00.4 07-Jul-06

Error handling added in ISQLCommand.prepare method implementation
Bug with processing NULL smallint values fixed

3.00.3 13-Apr-06

Bug with multithreaded access to Oracle 8 through same client fixed
Bug with RowID fields in Oracle 10.2.0.1 fixed
Bug with exception on calling GetFieldNames method fixed

3.00.2 09-Feb-06

Bug with invalid processing of widestring parameters (Delphi 2006) fixed

3.00.1 02-Feb-06

Delphi 2006 supported
Unicode support with coUseUnicode added (Delphi 2006)

2.50.5 6-Jul-05

Support of poFetchBlobsOnDemand option of TDataSetProvider added

2.50.4 13-May-05

Additional Prepared option added to TSQLConnection
Fixed bug with exception, raised on transaction operation fail
Bug with TParam.AsDate fixed (6949)

2.50.3 12-Apr-05

Performance of LOBs for Net option improved (6554)
Bug with wrong connection parameters on Kylix fixed (6667)

2.50.2 29-Mar-05

Bug with string params in UFT8 database fixed (6435)
Memory leak with TimeStamp parameter fixed (6408)
Bug with stored procedure parameters order on Oracle 8.0.5 fixed (6110)

2.50.1 27-Jan-05

Delphi 2005 supported
Performance of Net option improved
ARRAY fields supported
Bugs with editing OBJECT fields fixed (see ReadMe.html)
Bug with Net connection in multithreaded applications fixed
Bug with reading CLOB parameters from stored proc fixed
Bugs with FloatPrecision and BCDPrecision in TCRSQLConnection fixed

2.10.0 31-Aug-04

Ability to re-establish failed connection before executing query added
Ability to configure type of fields using SmallIntPrecision, IntegerPrecision, FloatPrecision, BCDPrecision added
Ability to trace SQL statements longer then 1024 with TSQLMonitor added
New time trial limitation

2.05 30-Jun-04

coIntegerPrecision, coSmallIntPrecision parameters added

2.00 14-May-04

Support for Delphi 8 added
Oracle 10g support added
Character conversion supported in Oracle 9i with Net option
Unicode character data supported with Net option
Performance improved

1.92 27-Feb-04

Bug with describing stored procedure fields fixed(3776)
Bug with TIMESTAMP parameter in stored procedure fixed(3850)
Bug with varchar2(4000) parameters using OCI fixed(4060)

1.91 10-Dec-03

Bug with ISQLMetaData.getColumns fixed(3755)

1.90 24-Nov-03

Bug with creating query if TSimpleDataSet.CommandType = ctTable fixet(3656)
Bug with UseQuoterChar parameter fixed(3681)
Bug with ISQLMetaData.getColumns fixed(3692)
Bug with TimeStamp parameter fixed (3699)

1.89 28-Oct-03

Additional option Charset to TCRSQLConnection available(3598)
Additional option RoleName to TCRSQLConnection available
Bug with using fractional part of Float fields fixed(3604)

1.88 17-Oct-03

Read TimeStamp precesion bug fixed (3284)
Bug with using DB Monitor in multithread applications fixed (3244)
Bug with stored procedure has not paremeters not appears in the list StoredProcName fixed (3552)
Bug in ISQLMetaData interface realization fixed
Additional option FetchAll to TCRSQLConnection available

1.87 22-Jul-03

Bug with ftTimeStamp parameter fixed

1.86 06-Jun-03

Bug with error handling while cursor fetching fixed
Bug with getting null status from Bcd fields fixed

1.85 21-May-03

Bug with monitoring fixed
Bug with describe parameters for stored procedures fixed
Bug with fetching numeric(*) type fixed

1.84 04-Apr-03

Additional option TrimFixedChar to TSQLConnection available
Bug with using DB Monitor fixed
Bug with LONG parameters fixed
Bug with RAW parameters fixed
Bug with DATE parameters in OCI9 and Oracle server 8.0.5 fixed
Bug with long number fixed
Bug with boolean parameters fixed

1.83 24-Feb-03

Bug with BCD fields fixed (2759)
Bug with long field names (more then 31 chars) fixed (2778)
Bug with '?' sign in string literals fixed (2797)

1.82 30-Jan-03

Bug with TIMESTAMP datatype in OUT parameters fixed
Bug with number expression represented as BCD fields fixed (2577)

1.81 26-Nov-02

Bug with string parameters fixed (2552)
DBMonitor client implementation moved to COM server
Additional option CharLength to TCRSQLConnection available

1.80 12-Nov-02

TCRSQLConnection component added
EnableBCD option is True by default now
Bug with Object fields support fixed
Support of DB Monitor added
Design-time packages for OraTools Add-in and DB Monitor added

1.71 17-Oct-02

Bug with AutoCommit fixed (2123)
Bug with double execute fixed (2102)
SimpleDataSet demo added

1.70 02-Oct-02

Delphi 7 support added
Oracle9 TIMESTAMP datatype support added
Now there is no additional roundtrip to server for select-list describe (OCIStmtExecute(DESCRIBE_ONLY) call).

1.60 04-Sep-02

Kylix3 support
Bug with memory allocation in multithreaded evironment fixed (1572)
Support for RowsetSize option added (1710)
Fixed bug with stored proc IN/OUT string parameters
Additional option UseQuoteChar to TSQLConnection available

1.53 22-Aug-02

Fixed bug with getting metadata in SQLMetaData.getTables

1.52 12-Jul-02

Additional option EnableBCD to TSQLConnection available
Fixed bug with binding parameters on Oracle9i client

1.51 05-Jul-02

Additional option LongStrings to TSQLConnection available
Additional option InternalName to TSQLConnection available

1.50 06-Jun-02

Driver version for Linux created
Source code available.
Limitation for trial version added.
TSQLMonitor support
Bug with StoredProc call on Oracle7 client. (1261)
Bug with date parameter fixed. (1267)

1.14 15-Apr-02

Bug with changing entry points in dll fixed. I.e when TSQLConnection.GetDriverFunc is set to getSQLDriverORA then getSQLDriverORANET.
Second connect in NET mode bug fixed.
Driver in NET mode can work with stored procedures now. (0932)
Bug with TSQLStoredProc.ExecProc call time increase fixed. (1034)

1.13 08-Apr-02

NET option is added to Demos. (0934)
Server name edit is added to Demos. (0935)
AccessViolation with parameter null values removed (ISQLCommand.SetParameter) (0985)

1.12 23-Mar-02

Transaction support bug fixed. TSQLConnection.StartTransaction raised error. Now it doesn't. (0828)
Metadata queries modified for compatibility with Oracle below 8i. (0819)

1.00 28-Jan-02

Initial release of the driver