Oracle Data Access Components (ODAC)

What's new in Oracle Data Access Components V8.0.1?

• Embarcadero RAD Studio XE2 now supported
• Application development for 64-bit Windows now supported
• FireMonkey application development platform now supported
• Support of master/detail relationship for TVirtualTable added
• OnProgress event in TVirtualTable added
• TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string added
• Bug with LOB parameters fixed
• Bug with OraLoader for Number(1,0) data type fixed
• Bug with Int64 data type for OraLoader fixed
• Bug with filling default values for inactive DataSet in design-time fixed

What's new in Oracle Data Access Components V7.20?

• Lazarus 0.9.30 and Free Pascal 2.4.2 support
• Oracle 9, Oracle 10, and Oracle 11 authentication in Direct mode is now supported
• Case sensitive login and password in Direct mode is now supported
• Unicode login and password in Direct mode is now supported
• Client Identifier in Direct mode is now supported
• Support of BLOB, CLOB, and NCLOB data types in ToraLoader has been improved
• Support of "table of blob/clob" data type has been improved
• Bug with 'SQL statement doesn't return rows' error if previous statement execution failed is fixed
• Bug with invalid update query for Blob fields if the roBeforeEdit option is set has been fixed
• Bug with preparing SQL statements that contain empty table parameters has been fixed
• Bug with error notification on invalid PL/SQL compilation in Direct mode has been fixed
• Bug in bookmark validity check has been fixed

What's new in Oracle Data Access Components V7.10?

• Added support for connections using Service Name in Direct mode.
• Improved returning cursors with different fields from TOraStoredProc
• Fixed Clob parameters reading and writing for charsets with varying character width
• Fixed search for the TNS_ADMIN variable in the Oracle root location in the registry.
• Fixed the GetOrderBy method
• Fixed moving data with the OraNumber data type by the TCRBatchMove component

What's new in Oracle Data Access Components V7.00?

• Embarcadero RAD Studio XE supported

What's new in Oracle Data Access Components V6.90?

• Embarcadero RAD Studio 2010 now suppored
• Now the subdetail is refreshed before the AfterRefresh event of the detail is called

What's new in Oracle Data Access Components V6.80?

• Added support for Free Pascal under Linux
• Added NoPreconnect property to TOraScript for executing CONNECT and CREATE DATABASE commands
• Restored old behaviuor of the Lock method (working without explicit transaction) for compatibility with old ODAC versions
• Bug with DetailDelay and refreshing closed dataset fixed
• Bug with detecting DBMonitor on 64-bit Windows fixed
• Bug with not calling UnregisterClient for internal command of dataset fixed
• Bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate fixed

What's new in Oracle Data Access Components V6.70?

• Delphi 2009 and C++Builder 2009 supported
• Extended Unicode support for Delphi 2007 added (special Unicode build)
• Free Pascal 2.2 supported
• Powerful design-time editors implemented in Lazarus
• Optimized LOB processing in Direct mode
• Completed with more comprehensive structured Help

What's new in Oracle Data Access Components V6.25?

• Oracle 11g supported
• CodeGear RAD Studio 2007 supported
• Added ability to customize whether update SQL statements should be prepared
• Added ability to set number of rows to be prefetched by OCI
• Added the OnProgress event in TOraLoader
• C++Builder 2007 supported

What’s new in V6.0?

New functionality:

• Delphi 2007 for Win32 supported
• Disconnected model for working offline and automatically connecting and disconnecting supported
• Local Failover for detecting connection loss and implicitly re-executing some operations supported
• LargeInt fields supported
• WideMemo field type in Delphi 2006 supported
• New tool for easily managing DataSets added
• Integration with OraDeveloper Tools 2.00 added
• New component for transferring data between all types of TDataSets descendants added
• Data export and import to/from XML supported
• Support for sending messages to DBMonitor from any point of your program added

Support for more Oracle server functionality:

• Distributed transactions supported
• Advanced Queuing support added
• Change notifications functionality of Oracle 10g supported
• DBMS_TRACE package and SQLTrace functionality supported
• OCI Connection Pooling, Statement Caching, and Proxy Session Pooling added

External Procedures support added

• Extensions and improvements to existing functionality
• General performance improved
• Master/Detail functionality extensions:
  • Local Master/Detail relationship support added
  • Master/Detail relationship in CachedUpdates mode support added
• Connection pool functionality improvements:
  • Efficiency significantly improved
  • API for draining the connection pool added
• TOraScript component improvements:
  • Support for executing individual statements in scripts added
  • Support for executing huge scripts stored in files with dynamic loading added
  • Ability to use standard SQL*Plus tool syntax added
• Greatly increased performance of applying updates in CachedUpdates mode
• Working with calculated and lookup fields improvements:
  • Local sorting and filtering added
  • Record location speed increased
  • Improved working with lookup fields
• Ability to customize update commands by attaching external components to TOraUpdateSQL objects added
• Support for using BeforeFetch and AfterFetch events in NonBlocking mode added
• Temporary LOBs for updating LOB fields supported
• Support for setting connection timeout values for Direct mode added
• Ability to include all fields in automatically generated update SQLs added
• Support for default field value expressions added

Usability improvements:

• Syntax highlighting in design-time editors added
• Demo projects became better organized and clearer

Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland Delphi, C++ Builder and Kylix. They serve for access to Oracle RDBMS. ODAC is an alternative to standard way processing data by Borland Database Engine (BDE).

ODAC uses Oracle Call Interface (OCI) directly. Also with Net option ODAC allows to connect without Oracle client software installed on workstation. In such cases ODAC requires only TCP/IP protocol and allows you to build really thin database applications.

Key features:

• Direct access to Oracle data. No distributing, installing and configuring the BDE and ODBC
• Doesn't require Oracle's software on client side with Net option and works directly through TCP/IP
• Extended Oracle data types support including XML types, LOB's, objects, nested tables, references, timestamps and intervals
• High performance controlled fetch of large data blocks
• Optimized string and raw data storing
• Easy work with Unicode data
• Automatic data updating with TSmartQuery and TOraTable components
• Automatic record locking and refreshing
• NonBlocking mode allows to run long lasting background queries in separate threads
• Oracle 9i scrollable cursors support
• Transparent Application Failover support
• Supports many Oracle specific features such as alerts, pipes and Direct Path interface
• Separated run-time and GUI specific parts allow to create pure console applications such as CGI
• SmartRefresh option allows two or more datasets to be synchronized automatically
• Local sorting
• Advanced design-time editors
• OraTools Add-in extending design-time capabilities by set of tools to build and check queries, design and debug PL/SQL blocks and explore database schemas
• Extended SQL tracing capabilities provided by TOraSQLMonitor component and DBMonitor application
• Includes source code of TCRDBGrid enhanced data-aware grid control
• Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport
• Easy migration from BDE
• Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications
• ODAC supports Oracle 10g, 9i, 8i, 8.0 and 7.3 including Personal and Lite

The following IDEs are supported by ODAC: Borland Delphi 2007, 2006, 2005, 8, 7, 6 and 5, C++ Builder 6 and 5, Kylix 3 and 2. Turbo Delphi, Turbo Delphi for .NET and Turbo C++ 

ODAC Editions

Oracle Data Access Components comes in three editions: ODAC Standard Edition and ODAC Professional Edition. ODAC Standard Edition includes the ODAC basic connectivity components and the ODAC Migration Wizard. ODAC Professional Edition includes additional components, access to Direct mode for connecting to the Oracle server directly over TCP/IP, and some advanced connection management features. ODAC Developer Edition is a bundle package of ODAC Professional Edition with OraDeveloper Tools, an advanced add-in for Oracle database development and administration.

Standard

• Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)
• Design-time features, including component editors and property editors
• Migration Wizard

Professional

• Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)
• Additional Components - (TOraNestedTable, TOraPackage, TOraAlerter, TOraLoader, TOraTransaction, TOraQueue, TOraQueueTable, TOraQueueAdmin, TOraChangeNotification, TOraTrace, TOraErrorHandler, TOraProvider, TBDESession, TCRBatchMove)
• Direct connectivity (connection without Oracle client)
• Design-time features, including component editors and property editors
• DataSet Manager
• Migration Wizard
• Smart Refresh in TSmartQuery component

Developer

• Base Components - (TOraSession, TOraQuery, TSmartQuery, TOraSQL, TOraTable, TOraStoredProc, TOraUpdateSQL, TOraDataSource, TOraScript, TOraSQLMonitor, TConnectDialog, TVirtualTable, TCRDBGrid, OraDataAdapter)
• Additional Components - (TOraNestedTable, TOraPackage, TOraAlerter, TOraLoader, TOraTransaction, TOraQueue, TOraQueueTable, TOraQueueAdmin, TOraChangeNotification, TOraTrace, TOraErrorHandler, TOraProvider, TBDESession, TCRBatchMove)
• Direct connectivity (connection without Oracle client)
• Design-time features, including component editors and property editors
• DataSet Manager
• Migration Wizard
• Smart Refresh in TSmartQuery component
• OraDeveloper Tools