What's new

Supported target platforms

  • Windows 32-bit and 64-bit
  • macOS 64-bit
  • Mac ARM
  • iOS 64-bit
  • Android 32-bit and 64-bit
  • Linux 32-bit and 64-bit

General usability

  • Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
  • Interface compatible with standard data access methods, such as BDE and ADO
  • VCL, LCL and FMX versions of library available
  • Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
  • Unicode and national charset support
  • Highly usable design time support
  • Easy to deploy

Network and connectivity

  • In Direct mode does not require Oracle client software and works directly through TCP/IP
  • Disconnected Mode with automatic connection control for working with data offline
  • Local Failover for detecting connection loss and implicitly reexecuting certain operations
  • Support for setting connection timeout values for Direct Mode
  • Support for OraNet.PacketSize to improve performance in VPN and Wireless networks
  • Secure connections with SSL, SSH, and HTTP/HTTPS tunneling (using SecureBridge)
  • Support for OS authentication
  • Support for Proxy Authentication
  • DBA privileges to open a session with
  • Support for Oracle 20c connection modes
  • Support for the change expired password
  • Connection using Service Name or SID in the Direct mode
  • Support for RAC Server
  • Support for both IPv6 and Ipv4 protocol
  • Support for IFILE in tnsnames.ora
  • Support for EZCONNECT connection string


  • Support for the latest versions of Oracle
  • Support for all versions of Oracle clients, including Instant Client
  • Support for all Oracle data types in both OCI and Direct modes
  • Support for Delphi 6, C++ Builder 6, and later versions up to RAD Studio 11.1 Alexandria
  • Support for Lazarus 2.2.2 and Free Pascal 3.2.2
  • Includes provider for UniDAC Express Edition
  • Support for reporting components, including InfoPower, ReportBuilder, FastReport
  • Support for all standard visual data-aware controls
  • Support for Professional Edition of Delphi and C++Builder for developing client/server applications.

Oracle technology support

  • Oracle Advanced Queuing support
  • Distributed transactions support with TOraTransaction component
  • Oracle package support
  • Support for Oracle alerts and pipes with TOraAlerter component
  • Support for Direct Path interface with TOraLoader component
  • Support for DBMS_TRACE package and SQLTrace functionality with TOraTrace
  • Support for Oracle Change notifications functionality of Oracle 10g with TOraChangeNotification component
  • Oracle Transparent Application Failover support
  • Oracle 9i scrollable cursor support
  • Multiple Oracle Homes support
  • Oracle sequence support
  • DML array operations support
  • Direct lob access support
  • Temporary LOB management routines
  • Temporary LOBs for updating LOB fields
  • OCI Connection Pooling, Proxy Session Pooling, and Statement Caching
  • Oracle optimizer control
  • ProxySession support
  • External Procedure support
  • Statement Caching
  • ROWID values retrieval
  • Overloaded stored procedures support
  • Support for WITH FUNCTION clause

Oracle data types

  • Support for all Oracle data types
  • Oracle Object (including NOT FINAL objects) types support
  • Support for Nested table
  • Support for PL/SQL table
  • Support for PL/SQL records
  • Support for REF CURSORs
  • Support for XMLTYPE datatype
  • Oracle 9i TIMESTAMP and INTERVAL data types support


  • High overall performance
  • Fast controlled fetch of large data blocks
  • Optimized string data storing
  • Advanced connection pooling
  • High performance of applying cached updates with batches
  • Caching of calculated and lookup fields
  • Expanded fields in TSmartQuery
  • Fast Locate in a sorted DataSet
  • Preparing of user-defined update statements
  • High performance batch processing
  • Intelligent fetch block size control
  • Advanced connection pooling
  • SmartFetch Mode enabling fast bi-directional navigation through large datasets

Local data storage operations

  • Database-independent data storage with TVirtualTable component
  • CachedUpdates operation mode
  • Local sorting and filtering, including by calculated and lookup fields
  • Local master/detail relationship
  • Master/detail relationship in CachedUpdates mode

Data access and data management automation

  • Automatic data updating with TOraQuery, TSmartQuery and TOraTable components
  • Automatic record refreshing and locking
  • Automatic query preparing
  • SmartRefresh option allows you to synchronize two or more datasets automatically
  • Support for ftWideMemo field type in Delphi 2006 and higher
  • Data Type Mapping
  • Support for Data Encryption in a client application

Extended data access functionality

  • Separate component for executing SQL and PL/SQL blocks
  • Simplified access to table data with TOraTable component
  • BLOB compression support
  • Support for using macros in SQL
  • NonBlocking mode allows background executing and fetching data in separate threads
  • Ability to customize update commands by attaching external components to TOraUpdateSQL objects
  • Deferred detail DataSet refresh in master/detail relationships
  • LargeInt fields support
  • MIDAS technology support
  • Ability to customize Oracle error messages with TOraErrorHandler
  • Structural representation and editing of Oracle objects
  • Fill DataSet with several REF CURSORs
  • Fill DataSet with object, array and nested table data
  • Object-oriented building of SELECT statements

Data exchange

  • Transferring data between all types of TDataSet descendants with TCRBatchMove component
  • Data export and import to/from XML (ADO format)
  • Ability to synchronize positions in different DataSets

Script execution

  • Advanced script execution features with TOraScript component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading
  • Ability to use standard SQL*Plus tool syntax in scripts

SQL execution monitoring

  • Extended SQL tracing capabilities provided by TOraSQLMonitor component and dbMonitor
  • Borland SQL Monitor support
  • Ability to send messages to dbMonitor from any point in your program
  • Display executing statement, all its parameters' values, and the type of parameters.

Visual extensions

  • Includes source code of enhanced TCRDBGrid data-aware grid control
  • Customizable connection dialog
  • Cursor changes during non-blocking execution

Design-time enhancements

  • DataSet Manager tool to control DataSet instances in the project
  • Oracle Package Wizard that simplifies working with PL/SQL Packages
  • Advanced design-time component and property editors
  • Automatic design-time component linking
  • Easy migration from BDE with Migration Wizard
  • More convenient data source setup with the TOraDataSource component
  • Syntax highlighting in design-time editors


  • Code documentation and guides in the CHM, PDF, and HXS formats
  • Many helpful demo projects

Licensing and support

  • Included annual ODAC Subscription with Priority Support
  • Licensed royalty-free per developer, per team, or per site