OracleClient Data Access Components (OracleClientDAC) is a feature-rich and high-performance library of components that provides native connectivity to Oracle from Delphi. 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.
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
- etc