Re: Delphi's native access to Oracle

vera_at_mda.ca (Felipe Vera) wrote:

>I'm confused about what Borland means when they say Delphi provides
>"native access" to Oracle.
 

>Does this mean that the Oracle Call Interface (OCI) is directly
>available at a programmatic level? Or is some subset of OCI available
>through Borland's Integrated Database API (IDAPI)? Most importantly,
>how much of the OCI functionality is available directly from Delphi's
>database controls?

The OCI is not available. All that 'native access' means is that Borland SQL*Links (part of Delphi Client/Server) talks directly to ORACLE's OCI interface, rather than going through an additional ODBC layer. The layers on the client PC are (I think).

Delphi Database Components
Borland BDE
Borland SQL*Links
ORACLE OCI
ORACLE SQL*Net

>Finally, could someone describe the default transaction model provided
>by Delphi's database controls?

It is somewhat configurable, although with ORACLE it is basically optimistic locking. No locking is performed until a row is posted (ie an update/insert or delete is performed). For updates and deletes, the default where clause (automatically generated) will include all selected columns, to make sure that none of them have changed since the row was originally selected.

Regards,
Michael Harvey
mgh_at_world.net
Brisbane, Australis Received on Wed Jan 03 1996 - 00:00:00 CET