Direct Oracle Access

Overview

 

 

If you are using Embarcadero Delphi or C++Builder to develop Oracle applications, then the Direct Oracle Access component set can help you to make a seamless integration between this great development tool and database system. Not only will your application take maximum advantage of both products, your application development process will also benefit from the following key features:

Features

High performance

Both online transaction and batch processing applications can benefit from Oracle’s performance features. Direct Oracle Access, as the name suggests, directly accesses the Oracle Interface. This guarantees optimal performance for standard database access functions. Support for Array Fetching, Array DML, PL/SQL Blocks, PL/SQL Tables, Local Statement Caching and the Direct Path Load Engine enable you to optimize your application’s performance critical functions even more.

Learn more 

Easy application distribution

A Direct Oracle Access application does not require middleware like the BDE or ODBC, it merely requires Oracle SQL*Net or Net8. Consequently you can deploy your application without many of the version dependency or configuration problems typically involved with middleware installation.

Learn more 

Oracle Package support

Most PL/SQL code in Oracle databases is programmed in packages. Direct Oracle Access provides a TOraclePackage component that allows you to easily call packaged program units without detailed declarations of these program units and their parameters.
Furthermore Direct Oracle Access includes a Package Wizard that can generate classes to encapsulate the program units and record types defined in packages. This will make your Oracle packages a natural extension of the Object Pascal or C++ language.

Learn more 

Advanced Queueing

To take advantage of the Advanced Queuing option of Oracle8 you can make use of the TOracleQueue component. The TOracleQueue component encapsulates the basic functionality of the DBMS_AQ package. It provides a convenient way to enqueue messages into a queue or to dequeue messages from a queue. Messages can be dequeued in a background thread of your application, and the events that are generated in threaded mode can occur synchronously or asynchronously with the main thread of your applicatio.

Session Pooling

In server applications that frequently need to create sessions to process requests from client applications, it may be useful to use connection pooling. Without a pooling concept, each request could lead to an actual database logon and logoff. By using the TOracleSessionPool component, you can maintain a pool of database sessions that can be used and reused for different requests. You can define the minimum an maximum number of sessions in the pool, define the TimeOut behavior for idle sessions in the pool, and preset the username, password and database.

Support for Oracle specific features

Direct Oracle Access supports many Oracle specific features. Besides the features mentioned above, it supports Oracle8 and Oracle8i features like LOB Locators, Objects & References, XMLTYPE, Timestamps, Scrollable Queries, Password Expiration, External Procedure development, and the Oracle Services for MTS.

System requirements

Direct Oracle Access requires a Windows 95, 98, ME, NT4, 2000, XP, Vista, Windows 7, Windows 8, Windows 10 or Windows 11 client, with Oracle SQL*Net, Net 8, Net 9, Net 10, Net 11, Net 12, Net 18, Net 19, Net 21, or Net 23 installed. The supported Oracle Server versions are 7.x, 8.x, 8i, 9i, 10g, 11g, 12c, 18c, 19c, 21c and 23c on any platform. Direct Oracle Access is available for all recent versions of Delphi and C++Builder.

Trial versions

You can download a fully functional trial version to try out Direct Oracle Access yourself. Visit our ordering page for ordering details and price information. We have a customer list available if you want to get an impression of what organizations are using Direct Oracle Access.

Pricing & Licensing

Standard or Object version
The Direct Oracle Access components are available in two versions, the Standard version and the Object version. The Object version allows you to use Oracle8’s Object extension through the TOracleObject and TOracleReference objects.

Oracle Monitor Pro option
The Oracle Monitor allows you to monitor the database activities that your Direct Oracle Access applications generate. The Lite version is available for free, and the Pro version can be purchased as an option for a Direct Oracle Access license. The Pro version includes additional features like database and network statistics, and query plan analysis.

Service Contract option
If you order an Annual Service Contract for a Direct Oracle Access license, you are entitled to technical support by e-mail and free product upgrades for the period of 1 year. Without this contract, you will receive only patch releases of the Direct Oracle Access version you purchased.
You can order the service contract directly with Direct Oracle Access or at a later time. The service contract can be renewed when it expires after 1 year.

Sourcecode option
You can additionally order the Sourcecode option, which is not related to the number of Direct Oracle Access licenses. Direct Oracle Access is programmed in Delphi, but the sourcecode can be compiled in C++Builder as well.

Pricing
Direct Oracle Access Standard license USD 129
Direct Oracle Access Object license USD 179
Oracle Monitor Pro (per license) + USD 50
Annual Service Contract (per license) + USD 50
Additional Sourcecode + USD 299

License terms
For every developer you need to purchase a Direct Oracle Access license and Monitor Pro license. You can additionally order the sourcecode, which may be used by all licensed developers.
You are allowed to build and sell any executable using the Direct Oracle Access components, no royalties are required. You are not allowed to distribute the registered (original or altered) components.

People love using Direct Oracle Acces