Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from Delphi, Delphi for .NET, C++Builder and Kylix. The ODAC library is designed to help programmers develop faster and cleaner Oracle database applications. ODAC is a complete replacement for standard Oracle connectivity solutions and presents an efficient native alternative to the Borlａnd Database Engine and dbExpress for access to Oracle.

特征综述 About Feature

Components
All editions of ODAC include the following basic components:

• TOraSession - lets you set up and control connections to Oracle
• TOraQuery - executes queries, operates record set, provides flexible way updating database tables with automatically building INSERT, DELETE, UPDATE statements
• TSmartQuery - easy in using traffic-efficient alternative to TOraQuery for working with large tables with lots of fields, includes Smart Refresh functionality in Professional and Developer Editions
• TOraTable - lets you retrieve and update data in a single table without writing SQL statements
• TOraStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter
• TOraSQL - executes SQL statements, PL/SQL blocks, stored procedures
• TOraScript - executes sequences of SQL and PL/SQL statements
• TOraUpdateSQL - lets you tune update operations for a DataSet component
• TOraNestedTable - controls nested table's data
• TOraDataSource - provides an interface for connecting data-aware controls on a form and ODAC dataset components
• TOraSQLMonitor - allows to monitor dynamic SQL executing in ODAC based applications
• TConnectDialog - allows you to build custom prompts for usernames, passwords, and server names
• TVirtualTable - provides dataset functionality for data that has no real database connection
• OraDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

• TOraPackage - provides a straightforward way to access Oracle packages
• TOraLoader - allows you to quickly load data into Oracle databases
• TOraAlerter - allows you to transfer messages between sessions
• TOraTransaction - provides discrete transaction control over sessions, can be used to manipulate both simple and distributed transactions
• TOraQueue - lets you monitor the message queue, provides an interface for enqueuing and dequeuing messages
• TOraQueueTable - manages queue tables
• TOraQueueAdmin - manages Oracle queues
• TOraChangeNotification - allows you to use Oracle Database Change Notifications
• TOraTrace - allows you to start and stop the SQL trace for a specified session
• TOraErrorHandler - translates error messages
• TBDESession - allows to integrate ODAC components into BDE based application
• TOraMetaData - retrieves metadata on specified SQL object
• TOraProvider - provides data to and applies updates from a client dataset
• TCRBatchMove - transfers data between all types of TDataSet descendants

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• In Direct mode does not require Oracle client software and works directly through TCP/IP
• VCL, VCL.NET, and CLX versions of library available
• Full support of the latest versions of Oracle
• Support for all Oracle data types
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly re-executing certain operations
• Oracle Transparent Application Failover support
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TOraQuery, TSmartQuery, and TOraTable components
• Unicode and national charsets support
• Distributed transaction support
• Oracle Advanced Queuing support
• Support for many Oracle-specific features, such as alerts, pipes and direct path interface
• Advanced script execution functionality with TOraScript component
• Support for using Macros in SQL
• Integration with OraDeveloper Tools for performing advanced database development and administration tasks
• Easy migration from BDE with Migration Wizard
• Lets you use Professional Edition of Delphi, C++Builder, and Kylix to develop client/server applications
• Includes annual ODAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site

Devart