Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

Thread: OracleClientDAC for Delphi

Permlink Replies: 0
Bismark Appah

Posts: 26
Registered: 3/13/15
OracleClientDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 29, 2017 1:56 AM
OracleClient Data Access Components (OracleClientDAC) is a feature-rich and high-performance library of components that provides native connectivity to Oracle from Delphi for both 32-bit and 64-bit Windows platforms. OracleClientDAC-based applications connect to Oracle directly through the ADO.Net OracleClient, which is an Oracle Data Provider for .NET (ODP.Net). OracleClientDAC aims to assist programmers in developing of fast and native Oracle database applications. OracleClientDAC allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, self-tuning statement cache, and fast connection failover.

OracleClientDAC, a high-performance and feature-rich Oracle connectivity solution, is an efficient native alternative to the Borland Database Engine (BDE) and standard dbExpress driver. It provides both possibility of connection to Oracle by means of native Oracle data access and direct access to Oracle without Oracle Client.

OracleClientDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE or ODBC), uses ADO.Net technology and that's why they can work faster than the ones based on standard Delphi data connectivity solutions.

NB: OracleClientDAC is part of the ADO.Net VCL for Delphi.

Key Features:
- 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
- Unicode and national charset support
- Easy to deploy
- Local Failover for detecting connection loss and implicitly reexecuting certain operations
- Transmission is via XML format, therefore can pass through firewalls
- Full support for the latest versions of Oracle
- Support for all versions of Oracle Clients, including Instant Client
- Support for all Oracle data types
- Distributed transactions support
- Oracle Transparent Application Failover support
- Statement Caching
- High overall performance
- Fast controlled fetch of large data blocks
- High performance of applying cached updates with batches
- Advanced connection pooling
- High performance batch processing
- Intelligent fetch block size control
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property
- CachedUpdates operation mode which is controlled UpdateMode property
- Automatic data updating with TOracleClientQuery, TOracleClientTable, and TOracleClientStoredProc components
- Fast data retrieval with TOracleClientDataReader component
- Automatic record refreshing and locking
- Automatic query preparing
- Data export and import to/from XML
- Advanced design-time component and property editors
- and many more

For more information go to
For more information about ADO.Net VCL for Delphi, go to
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02