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 ... ...
近期下载者:
相关文件:
收藏者: