oracle_on_cbuilder

所属分类Oracle数据库
开发工具:Visual C++
文件大小:514KB
下载次数:804
上传日期:2001-01-01 00:00:00
上 传 者管理员
说明:  C++Builder上存取Oracle的控件源码。直接使用OCI
(The controls source for accessing Oracle in C++ Builder, using OCI directly)

文件列表:
Contacts.html (448, 1999-03-11)
Demos (0, 1999-06-16)
Demos\BDESession (0, 1999-06-16)
Demos\BDESession\BDESess.cfg (511, 1999-05-17)
Demos\BDESession\BDESess.dof (1377, 1999-05-17)
Demos\BDESession\BDESess.dpr (188, 1999-05-01)
Demos\BDESession\BDESess.res (876, 1999-05-17)
Demos\BDESession\Main.dfm (2839, 1999-05-26)
Demos\BDESession\Main.pas (2001, 1999-05-17)
Demos\CachedUpdates (0, 1999-06-16)
Demos\CachedUpdates\Cached.dof (1525, 1999-03-26)
Demos\CachedUpdates\Cached.dpr (303, 1999-03-26)
Demos\CachedUpdates\Cached.res (876, 1998-08-20)
Demos\CachedUpdates\Main.dfm (3819, 1999-05-16)
Demos\CachedUpdates\Main.pas (5097, 1999-03-27)
Demos\CachedUpdates\UpdateAction.dfm (847, 1999-03-27)
Demos\CachedUpdates\UpdateAction.pas (516, 1999-03-27)
Demos\CBuilder (0, 1999-06-16)
Demos\CBuilder\CBuilder.bpr (5452, 1999-05-17)
Demos\CBuilder\CBuilder.cpp (646, 1999-01-31)
Demos\CBuilder\CBuilder.res (876, 1999-05-17)
Demos\CBuilder\Main.cpp (1642, 1999-01-31)
Demos\CBuilder\Main.dfm (2230, 1999-05-17)
Demos\CBuilder\Main.h (1552, 1999-01-31)
Demos\CLOB (0, 1999-06-16)
Demos\CLOB\CLOB.cfg (325, 1999-04-29)
Demos\CLOB\CLOB.dof (997, 1999-05-06)
Demos\CLOB\CLOB.dpr (185, 1999-05-06)
Demos\CLOB\CLOB.res (876, 1999-04-14)
Demos\CLOB\Main.dfm (4765, 1999-05-20)
Demos\CLOB\Main.pas (5277, 1999-05-06)
Demos\Cursor (0, 1999-06-16)
Demos\Cursor\Cursor.dof (1268, 1999-01-09)
Demos\Cursor\Cursor.dpr (187, 1998-09-14)
Demos\Cursor\Cursor.res (876, 1998-09-19)
Demos\Cursor\Main.dfm (1842, 1999-05-16)
Demos\Cursor\Main.pas (998, 1999-01-10)
Demos\Detail (0, 1999-06-16)
Demos\Detail\Detail.cfg (387, 1999-04-19)
Demos\Detail\Detail.dof (1362, 1999-04-19)
... ...

Oracle Data Access Components (ODAC) library offers some nonvisual components for Borland Delphi and C++ Builder. 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) directrly. The Oracle Call Interface is an application programming interface (API) that allows an application developer to use a third-generation language's native procedures 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. 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. 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] Version 1.85 ODAC includes following components: TOraSession - controls server connection; TMemDataSet - base class for TOraDataSet and TVirtualTable; TOraDatSet - base class for TOraQuery and TSmartQuery; TOraQuery - queries execution, operates record set, flexable way updating database tables; TSmartQuery - easy in using and an alternative to TOraQuery, automotically builds INSERT, DELETE, UPDATE queries, automatic locking and refreshing records; TOraSQL - executes SQL statements, PL/SQL blocks, stored procedure; 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; TOraProvider - provides data to and applies updates from a client dataset; TBDESession - allows to integrate ODAC components into BDE based application; TConnectDialog - serves for enter username, password and server name; TOraErrorHandler - translates error messages; TVirtualTable - dataset stores data in memory. Using Oracle Data Access gives you the following advantages: - No distributing, installing and configuring the BDE and ODBC; - You can use any Delphi Professional Edition to develop client/server application; - Enables you to use many Oracle specific features; - Supports Oracle 8 feathers: BLOB and CLOB data types, nested tables; - Simplifies data updating; - Offers two way of updating data: more flexable with TOraQuery and more easy with TSmartQuery; - Speeds up fetch record from database; - Provides automatic locking and refreshing records; - Allows to execute longtime stored procedure separated thread; - Each component have thread component editor; - Interface (methods, properties) of ODAC components is similar to standard BDE data access components (TDatabase, TQuery, ..); - Supports all data-aware components; - Include SQL Designer for build queries and design and debug PL/SQL blocks; - and so on. Compatibility ODAC supports Oracle 7.3, Oracle 8.0 and Oracle 8i. ODAC for Delphi 4 requires Update Pack 3 (Delphi 4 Build 5.108). Installation Delphi Select the Delphi Component/Install Packages menu. Press the Add button and select the Package collection (*.dpc) filetype. Select the ODAC.dpc file from the ODAC directory and press OK. Now follow the instructions of the installation wizard, you shouldn't need to change any option. Components is ailable in the Oracle Access group. All files will be copied to the lib directory by default when instal ... ...

近期下载者

相关文件

评论我要评论

收藏者