医院信息管理系统 delphi

Oracle Data Access Components 4.50 Copyright 1997-2003, Core Lab. All Rights Reserved -------------------------------------------------- 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. 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. 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 9i, 8i, 8.0 and 7.3 including Personal and Lite. Following IDE are supported by ODAC: Borland Delphi 7, 6 and 5, C++ Builder 6 and 5, Kylix 3 and 2. Only Professional and Enterprise editions are supported. ODAC does not support Kylix Open Edition. Installation ------------ Since ODAC 3.20 run- and design-time packages are separated. ODAC installer copies these files to folders where they should be resided. 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) Delphi ====== To compile ODAC based application add $(DELPHI)\ODAC\Lib to Project Options|Search path. 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:<ODAC directory> Another way is to copy all ODAC packages (*.so) to any reachable directory, for example kylix/bin. Now you can install ODAC in Kylix IDE. Please select Component/Install Packages from Kylix menu. Press Add button and select bpldclodacX.so.X.XX package. On pressing OK button components are available in Oracle Access group. Also you should add odac/lib directory to Search Path of your project. TOraProvider component ====================== If you use Delphi or C++ Builder Enterprise edition you can install TOraProvider component separately. To do it compile and install oraprovXX.bpk package. OraTools add-in =============== Since ODAC 3.50 oratoolsXX.bpl design-time package doesn't exist. OraTools now is provided as a separate add-in. It is installed once and can be used by Delphi and C++ Builder. Kylix is not supported by now. Writing GUI applications with ODAC ---------------------------------- Since version 3.80 ODAC GUI part is standalone. This means that to make available GUI elements such as sql cursors, connect form, connect dialog etc. you should explicitly include OdacVcl (OdacClx under Linux) unit to your application. This feature is needed for writing console applications especially under Linux. Delphi and C++ Builder ====================== By default ODAC does not require Forms, Controls and another GUI related units. Only TConnectDialog and TOraErrorHandler components require Forms unit according to their needs. Kylix ===== By default ODAC does not require QT libra