dbExpress Driver for Oracle Revision History

8.4.0 06-Apr-26

  • Added support for RAD Studio 13 Florence Release 1
  • Added support for Oracle 26ai
  • Added support for the JSON data type in Oracle 21c and later

8.3.0 22-Sep-25

  • Added support for RAD Studio 13 Florence
  • Added support for passwords longer than 30 characters in Direct mode for Oracle 23
  • Fixed an issue with the TSQLConnection.GetTableNames method not returning the correct table list from the SYS schema

8.2.0 25-Mar-25

  • Added support for RAD Studio 12 Athens Release 3
  • Added support for the RAD Studio 64-bit IDE
  • Added support for the BOOLEAN data type in Oracle 23 and higher
  • Improved query performance for obtaining a primary key

8.1.2 31-Oct-24

  • Added support for RAD Studio 12 Athens Release 2
  • Fixed bug with connecting to patched Oracle 19 and higher in the Direct mode

8.1.1 09-May-24

  • Added support for RAD Studio 12 Athens Release 1
  • 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

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