Oracle Data Access Components

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

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 12 Athens
Support for Lazarus 3.0 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 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
CLIENT_IDENTIFIER support
Statement Caching
ROWID values retrieval
Overloaded stored procedures support
Support for WITH FUNCTION clause

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

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

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

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.