Direct Oracle Access

Allround AutomationsData Access ToolsVCL Component
Version 4.1.4.1 (Oct 3, 2025)(2)

Delphi components providing direct, high-performance Oracle database integration.

  • Provides direct access to Oracle databases through the Oracle Call Interface (OCI).
  • Includes components for working with datasets, queries, and PL/SQL packages.
  • Supports Oracle-specific data types and features for Delphi and C++Builder applications.
Allround Automations logo

Prices from:

Loading...
Available individuallyOur Price
Direct Oracle AccessLoading
High Oracle performance for Delphi and C++Builder developers.
Direct Oracle Access is a component set for Delphi and C++Builder that enables direct interaction with Oracle databases. It communicates through the Oracle Call Interface (OCI) to deliver high performance and supports Oracle-specific features such as PL/SQL packages, allowing developers to build Oracle applications without requiring BDE or ODBC.

High Performance

Direct Oracle Access communicates directly through the Oracle Call Interface (OCI), ensuring optimal database performance. Features such as Array Fetching, Array DML, and Local Statement Caching further improve the speed of transaction and batch processing.

Easy Application Distribution

Applications built with Direct Oracle Access require only the Oracle client libraries and avoid middleware dependencies such as BDE or ODBC, simplifying deployment and reducing configuration issues.

Oracle Package Support

The TOraclePackage component enables easy calling of PL/SQL packaged program units without detailed parameter declarations. The Package Wizard can generate classes encapsulating Oracle package units and record types for use in Object Pascal or C++.

TOracleDataSet Component

This dataset component supports Oracle record locking, record refreshing, server-generated values, and automatic sequence generation. It dynamically reads Oracle Dictionary information to enforce server constraints, default values, and master/detail relationships without recompilation.

Query By Example Mode

TOracleDataSet includes a Query By Example mode that allows building QBE forms without additional programming or components. Queries execute on the Oracle server using operators and wildcard characters for efficient filtering.

Oracle Monitor Utility

Oracle Monitor provides real-time monitoring of database activity, displaying SQL statements, execution times, network statistics, and query execution plans. The Pro version includes additional performance tuning and debugging features.

Alert and Pipe Events

The TOracleEvent component handles Oracle dbms_alert and dbms_pipe events asynchronously in a background thread, allowing applications to respond to database events without interrupting main processing flows.

SQL Scripts Execution

The TOracleScript component automates execution of multiple DDL statements using an extendable SQL*Plus-like script language with support for substitution variables.

Advanced Queueing Support

The TOracleQueue component encapsulates Oracle Advanced Queuing functionality, enabling message enqueue and dequeue operations with optional background processing and event-driven handling.

Session Pooling

The TOracleSessionPool component provides reusable database sessions for applications requiring frequent logins, reducing connection overhead and allowing configuration of pool size, timeouts, and credentials.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • VCL Component

IDE Support

  • C++Builder
  • Delphi
  • RAD Studio