ORACLE DATA ACCESS KEY BENEFITS

Direct Access to Oracle Database via Oracle Call Interface (OCI) ODA components gain an access to Oracle Database via Oracle Call Interface and skip BDE. Professional Edition of Delphi is enough to create, compile and distribute true client/server applications.

Borland SQL monitor support Oracle Data Access Engine (SQL) log is made available in Borland SQL Monitor. This facility allows you debugging ODA applications as well as BDE applications.

Nested transactions Oracle Data Access components support Oracle nested transactions (save points). Use BeginTrans method of TOraConnection to start nested transaction. Check TransactionLevel property to determine the current level of nested transaction.

Auto Read feature after update and/or insert Use Reread feature of TOraTable object to force Oracle Data Access engine to retrieve a row from the server immediate after that row has been inserted/updated. It is recommended to use this feature for tables with triggers and default values. This feature allows user to see an actual data that is saved in database.

Mature BLOB support ODA provides the set of properties: CachedBlobCount, ActiveBlobSize, CachedBlobSize, MaxBlobSize, MinBlobSize that allow your application subtle tuning of Blob data. You can customize these properties at both TOraDataset and TOraConnection instances levels

Parameters support TOraTable component supports parameters as well as TOraQuery and TOraStoredProc. You can use parameters in Filter property of TOraTable and TOraQuery.

Fetch Tuning Fetch Tuning allows to specify the number of rows that will be retrieved from the Oracle server in a single fetch. You can customize this value for each instance of TOraTable and TOraQuery. TOraConnection properties allow you to specify default fetch values. In actual practice, tuning this value for different row sources allows winning an additional performance improvement.

Improved Sorting Facilities TOraTable allows to order data by non-indexed fields as well as by indexed fields. Data can be ordered ascending and descending. Result set always remains live.

Advanced Master/Detail Child dataset is enables to use any object derived from TDataSet as a Master dataset. For example, you can set as Master any BDE dataset as well as ODA dataset.

Oracle PL/SQL tables support Oracle8i multiple Oracle home architecture support Oracle Data Access goes with full sources Easy Installation Oracle Data Access components compile into project. It is make your products easy to install and distribute.