Oracle Data Access Components provides high performance direct access to Oracle database server. ODAC is set of VCL native components for Delphi, C++ Builder, and Kylix.
Oracle Data Access Components supports many Oracle specific features and simplifies developing of client/ server applications.
With Net option ODAC works directly through TCP/IP and doesn't require Oracle's software on client side. ODAC can work in managed environment and support .NET Framework.
ODAC supports Oracle 10g, 9i, 8i, 8.0 and 7.3, including Personal Edition, and Oracle 8 Lite. Following development environments are supported by ODAC:
· Borland Delphi 2005
· Borland Delphi 8
· Borland Delphi 7
· Borland Delphi 6
· Borland Delphi 5
· Borland C++ Builder 6
· Borland C++ Builder 5
· Borland C++ Kylix 3
· Borland C++ Kylix 2
· 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.
Limitations:
· 60 days trial
What's New in This Release:
· Lazarus 0.9.30 and FPC 2.4.2 is supported
· Oracle 9, Oracle 10, and Oracle 11 authentication in the Direct mode is supported
· Case sensitive login and password in the Direct mode is supported
· Unicode login and password in the Direct mode is supported
· Client Identifier in the Direct mode is supported
· Support of BLOB, CLOB, and NCLOB data types in ToraLoader is improved
· Support of "table of blob/clob" data type is 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 is fixed
· Bug with preparing SQL statements that contain empty table parameters is fixed
· Bug with error notification on invalid PL/SQL compilation in the Direct mode is fixed
· Bug in bookmark validity check is fixed