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) 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.
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.
New features in ODAC 3.00
--------------------------------------------------------
- using standard TParam object
- separate run- and design-time packages
- get original name of fields
- retrieve field's default value
- support Net option
- Kylix ready
TOraSession
property Options.Charset: String;
property Options.Net: Boolean;
TOraDataSet
property OptionsDS.FieldsOrigin: Boolean;
property OptionsDS.DefaultValues: Boolean;
TOraTable
property MasterFields: String;
property DetailFields: String;
TOraObject
AttrAsLob[Name: string]: TOraLob;
TOraParam
TOraParams