ODAC_SDAC.rar_delphi ODAC_delphi odac_odac sdac_sdac

Core Lab Oracle Data Access Components 5.70 Copyright 1997-2006, Core Lab. All Rights Reserved -------------------------------------------------- Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland Delphi for Win32, Borland Delphi for .NET, C++ Builder, 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. The Oracle Call Interface is an application programming interface (API) that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. The OCI provides a library of standard database access and retrieval functions in the form of a dynamic runtime library, ORA*.DLL, that can be linked in by the application. Also with Net option ODAC allows to connect without Oracle client software installed on workstation. In such case ODAC requires only TCP/IP protocol and allows to build really thin database application. Using BDE in Oracle oriented client/server applications has some deficiencies. So in consequence of BDE community get unable server specific features, use more resources, reduce speed of processing data, cumbrous distribution of an application and its administration. In case of using BDE transfer way of data is: [Oracle RDBMS] <> [SQL*Net] <> [OCI] <> [SQL Links] <> [BDE] <> [Application] ODAC works directly through Oracle Call Interface. It allows to avoid using BDE and SQL Links: [Oracle RDBMS] <> [SQL*Net] <> [OCI] <> [Application] ODAC Net provides optimal transfer way: [Oracle RDBMS] <> [TCP/IP] <> [Application] ODAC includes following components: TOraSession - controls server connection; TOraQuery - queries execution, operates record set, flexible way updating database tables; TSmartQuery - easy in using and an alternative to TOraQuery, automatically builds INSERT, DELETE, UPDATE queries, automatic locking and refreshing records; TOraSQL - executes SQL statements, PL/SQL blocks, stored procedure; TOraPackage - allows to execute package procedures and functions and provides access to package variables; TOraTable - allows to retrieve and update data single table without writing SQL statement; TOraStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter; TOraNestedTable - controls nested table's data; TOraProvider - provides data to and applies updates from a client dataset; TOraScript - executes sequence of SQL and PL/SQL statements; TOraAlerter - allows to transfer messages between sessions; TOraLoader - provides quick loading data to Oracle database; TOraSQLMonitor - allows to monitor dynamic SQL executing in ODAC based applications; TOraErrorHandler - translates error messages; TBDESession - allows to integrate ODAC components into BDE based application; TConnectDialog - serves for enter username, password and server name; TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search; TVirtualTable - dataset stores data in memory. OraDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet Features -------- Following list describes the main features of Oracle Data Access Components: - 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; - 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; - Wide data-aware and reporting components support; - Easy migration from BDE; - Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications. Compatibility ------------- ODAC supports Oracle 10g including Express Edition, 9i, 8i, 8.0 and 7.3 including Personal and Lite. Following IDE are supported by ODAC: Borland Delphi 2006, 2005, 8, 7, 6 and 5, C++ Builder 6 and 5, Kylix 3 and 2. Architect, Professional and Enterprise editions are supported. ODAC does not support Kylix Open Edition. Note: Update Pack 3 is required for Delphi 8 Update Pack 2 is required for Delphi 6 (Build 6.240) Installation ------------ ODAC installer copies these files to folders where they should be resided. The following packages are used with Delphi 5, Delphi 6, Delphi 7, Delphi 2005, Delphi 2006, C++ Builder 5, C++ Builder 6 projects: dacXX.bpl - DAC run-time package (located in Windows\System folder) dcldacXX.bpl - DAC design-time package (located in Delphi\Bin folder) dacvclXX.bpl - DAC VCL support package (located in Delphi\Bin folder) odacXX.bpl - ODAC run-time package (located in Windows\System folder) dclodacXX.bpl - ODAC design-time package (located in Delphi\Bin folder) odacvclXX.bpl - VCL support package (located in Delphi\Bin folder) oraprovXX.bpl - TOraProvider component (located in Delphi\Bin folder) crcontrolsXX.bpl - TCRDBGrid component (located in Delphi\Bin folder) The following packages are used with Delphi 2006, Delphi 2005, Delphi 8 projects: CoreLab.Dac.dll - DAC run-time package (located in Global Assembly Cache) CoreLab.Dac.Design.dll - DAC design-time package CoreLab.Odac.dll - ODAC Delphi 8 run-time package (located in Global Assembly Cache) CoreLab.Odac.Design.dll - ODAC design-time package CoreLab.Vcl.dll - TCRDBGrid component CoreLab.Odac.AdoNet.dll - OraDataAdapter component Delphi ====== To compile ODAC based application add $(DELPHI)\ODAC\Lib to Project Options|Search path. Delphi for .Net =============== To register OraDataAdapter component in Delphi 2006, Delphi 2005, Delphi 8 Tool Palette follow these steps: - Open Delphi and go to "Tool Palette" window; - Add "ODAC" category using popup menu; - Select "Installed .NET Components..." from popup menu; - Go to "Installed .NET Components" tab within opened dialog; - Check OraDataAdapter component; - Press OK button. To compile ODAC based application add CoreLab.Dac and CoreLab.Odac to Namespace prefixes. C++ Builder =========== To compile ODAC based application add $(BCB)\ODAC\Lib to Project Options|Library path and $(BCB)\ODAC\Include to Project Options|Include path. Kylix ===== At first it is required to get ODAC packages reachable for Kylix IDE. To do it you should add directory where ODAC packages are installed to LD_LIBRARY_PATH using following command LD_LIBRARY_PATH=$LD_LIBRARY_PATH: