Direct Oracle Access
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.
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.
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.
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
“I love DOA. It is clean, efficient code. I highly recommend it.”
John Santmann MD, Wellsoft Corporation“Thanks once again for an excellent product – I constantly use DOA in my ORACLE projects in the safe knowledge that it will always deliver – and it does. Furthermore, even after all this time using it, I am STILL discovering features that I didn’t imagine it possessed!”
David Mustard, Time Warner Publishing“… Oh, and I still think these components are worth their weight in gold. Easy to use. Incredibly robust. Beautifully documented.”
Emily Campbell, Oregon Health and Science University“We used Direct Oracle Access in a CGI application that was using the BDE. The difference is amazing. No Production errors whatsoever. In addition, in case of errors during debugging, it was easy to see what the error was through the web browser, instead of the silly and generic BDEException errors that really did not tell us anything. Great work and thanks.”
Maan Hamze, Texas Secretary of State“I’ve purchased a number of add-on components for Delphi over the last couple of years and can honestly say that DOA is the best. It combines simplicity and flexibility in a way other third-party components often lack. Thanks again for a great set of components.”
Neil W. Garside, Bechtel“DOA is great. This is a first class product. I’ve saved a lot of time. The applications are working fast and stable (Delphi 5 / Oracle 8). Especially the run time of an import-job with many thousands of insert/update statements is 15x faster as the same with Borland-BDE. Other Client/Server applications (combined with InfoPower 2000 for Desktop) are better too. Excellent product, excellent technical support (praise for FORUM).
Congratulations and thanks for DOA.”
Allan Karzel, VIT (Softwareentwicklung)“I feel I should point out once again our enormous satisfaction with, not only your products, which have their value recognized by software developers throughout the “Delphi developers world” and Borland itself, but also and particularly with your support, which is always fast, and as efficient as it could be.
I personally feel that it’s perhaps more important to highlight the qualities that something has than to dissect its problems and errors when they appear, so I could not let this opportunity pass by without stating that you are beyond the doubt the most efficient and satisfactory supplier/partner we have the pleasure to work with, and to let you know what this means, in this group companies like Oracle, Lotus, IBM, Microsoft among others are included.”
Pedro Viegas, Digitalis Informática Lda“One Year ago we were just about to throw our self-developed Delphi ERP-Application out of the window, because the performance was terrible (the BDE you know).
After getting a tip on the Delphi Super Page we tried the Trial Version of your Direct Oracle Access and we were absolutely excited and fascinated. So we purchased your incredible piece of software and started modifying the existing forms and continued developing with Delphi.
So what can we say now? 4 weeks ago our ERP-System went into Production for the whole company and it’s working absolutely fine and your components have a major part on it.”
Dirk Braunecker, mac messe- und ausstellungscenter Service GmbH“I must say, the more I use DOA, the more I wonder how I lived without it!! You folks sure have a wonderful product there. It has saved us so much time, effort, and money that it would have been a great bargain at twice the price. I use it in conjunction with Lars Aakerman’s CGI Expert control to put Oracle data on the web for our clients. It has been a very successful project. I also use it for all my Oracle front-end work. I love it.”
Dave Skowron, Kleinfelder, Inc.“DOA worked right the first time for me, unlike the BDE. It was faster and easier to program for. If you use Delphi with Oracle, I unconditionally recommend it. Thanks, Allround Automations!”
Jared Jennings, Municipal Tax Liens, Inc.“… by the way, DOA saved us 40 hours (70%) on a massive output run where we were creating ANSI Z39.2 (ISO 2709) format records from the Oracle database.”
Howard Flank, Flank Associates“Having used DOA for a few weeks now, I must congratulate you on producing a product that actually lives up to its promises. Having experienced a prolonged nightmare using the BDE with Oracle & ODBC, finding DOA was like finding the Holy Grail of database access components. Performance is outstanding & the Oracle specific support is truly magical. Before I found DOA I was about to abandon Delphi (extremely reluctantly) for Client/Server applications, so I thank you for restoring my optimism.”
Rob Lester, Staffordshire County Council“This is a fantastic product. Our Oracle application dropped from 6 compressed installation disks with the BDE down to a single floppy with DOA, and the speed increase is visibly noticeable when the app. runs. Completely awesome!”
Anthony Stuchel, Future Horizons, Inc.“Thanks for a great product, guys. I am redeveloping a major application from Oracle Forms/ReportWriter to Delphi3 and DOA is saving me an enormous amount of time and effort by removing the need to write a single line of code for record locking etc.”
Dr. Harry Smith, Le Reve Cosmetics“Direct Oracle Access is great product for software developers who uses both Delphi 3 and Oracle. It provides flexibility and effectiveness of the Oracle Call Interface encapsulated in comfortable and suitable Delphi components. Very nice TOracleDataset component enables you to use visual components like grid to access oracle data in very simple manner without programming. There are no setup, configuring and performance overhead as in IDAPI or ODBC. Nice, fast and easy to use product.”
Andrew Protasov,“Since 7 years we tried most of the Client/Server development tools and used some of them, nothing comes close to using Delphi with DOA. You get the easiest prototyping with Delphi and Raw Oracle power with DOA. The combination of both tools is unique for Oracle users building applications on Windows NT. And your technical support is outstanding even for demanding users like us. Thank you!”
N.F., SetNet Corporation“Using DOA with C++ Builder has made my life and the LAN administrators lives a lot easier. Without BDE DLLs, especially configuring and distribution, my programs are more robust, quicker, and easier to troubleshoot.”
E. Woo, Wells Fargo Bank“I must say your code is awesome. It has allowed us to create some real dynamite stuff with some extremely good results. Needless to say, we like it very much.”
R.V., National Board of Medical Examiners“Thanks for the super product! We continue to be impressed with design and performance of your components.”
H.K., Howell & Johnson“In addition to offering performance improvements, many issues that arise from using Delphi with Oracle have been addressed. Anyone using Oracle with Delphi 3 should consider DOA.”
R.D., Advanced Media Systems“Impressive and easy to use product. I especially like how the variants make the coding easier, and the “easy” support for LONG fields.”
Ian Johnstone, LNS Software Systems Inc.“My congratulations for this excellent product. Not only does it deliver exactly what I need but it also comes with precise, short documentation where an answer on every question is found almost instantly. You seem to have the guts to concentrate precisely on the important things, which is in no way obvious.”
H.R., Landshut