Home | 10% - Off! | New | VCL | DB-Aware | Tools | DB Tools | Apps | Samples | .NET | .NET DB-Aware | .NET Tools | .NET Samples | Kylix | Docs | Bold | Discussion | Sites | Tips | DPFL | Authors | Uploads | RSS | Store | Advertisement | About
DB-Aware Components

DB Access
Direct DB Access
MS Access
MS Excel
Pervasive DB
MS Other
Memory Tables
Interbase and Firebird
DB-Aware Components > Direct DB Access > Oracle  

Companies News:

New Rosi Components Package released
New Rosi Components Package released Create feature-rich windows applications with many new components and universal dialogs.
  • improved DBGrid
  • new DBRecordView, DBTreeView
  • toolbars and db dialogs to Find, Filter, Sort, Export, Print...
  • StringGrid with columns definition
  • GroupBox with automatic alignment and resizing of owned controls
And many more for $35 only - details here
Want to know more ?


ATOM Access To Oracle Magic v.1.0FWS 26 k 22 Oct 1999
By Albert A. Mavrin. This components like the Delphi standard components TDatabase and TQuery. It implements a encapsulation of access to Oracle databases.

Main features:

  • Not needed distribution of BDE with projects.
  • More fast access to data.
  • For working with Oracle enough Delphi professional version (you can save ~$2000).

Fully functional
Source: Included
Download: CB4 CB5 D4 D5  Homepage

Direct Oracle Access v. 2584 - 3849 k 15 Sep 2010
By Allround Automations. With these three components you access an Oracle database directly, skipping the Borland Database Engine only using (32 bits) SQL*Net. This gives you the following advantages:
  • No distributing, installing and configuring the BDE
  • No BDE overhead or trade offs: your queries will run up to five times faster
  • The program executable size will be more than 100K smaller
  • The use of variants makes programming easy (null values, runtime type information)
  • You can use PL/SQL blocks for server logic in your application
  • Easy to use, the components are intelligent.

Trial (work while IDE is running)
Source: On purchase/registration
Price: $129
Source Price: $299
Download: C2k10 C2k6 C2k7 C2k9 CB3 CB4 CB5 CB6 CBXE D2005 D2006 D2007 D2009 D2010 D3 D4 D5 D6 D7 DXE  Register NowHomepage

DOCI Components for Direct Oracle Access v.1.18FWS 126 k 06 Dec 2002
By Andrey Romanchenko. Components for direct access to Oracle databases:
  • Can work with Oracle 7.3/8/8i using client part from Oracle 8/8i.
  • There is a powerful TDataSet descendant - TOraSQL. It implements all capabilities of TDataSet and adds new.
  • There is a complete implementation of ORACLE BLOB and CLOB column datatypes.
  • There is a capability for stored procedures execution.
  • There is a capability for PL/SQL code execution without stored procedures creating.
  • Number of records to be fetched from Oracle server per one network roundtrip can be customized (performance gain upon large tables).
  • There are fast and powerful memory tables (TMemoryDataSet, TAMemoryDataSet).
  • There are many nice components for working with dynamic arrays to store and handle all types of data (search implemented using assembler, therefore is extremely fast).

Fully functional
Source: Included
Download: D4 D5 D6 D7  Homepage

NC OCI8 v.1.0.6FWS 688 k 15 May 2007
By Dmitry Arefiev. This is a component library for direct access to Oracle8/9/10g servers. Now set includes 10 core components:
  • TOCIDatabase: Analog of TDatabase. It must be used for opening connection to Oracle server. Also the component have a lot of properties, that tune library behavior.
  • TOCITransactionManager: It is a transaction manager. It must be used for take advantages of NCOCI8 multiple parallel transaction support and for fine grain tune of transactions.
  • TOCIQuery: Analog of TQuery. It must be used for executing queries to server and for editing data.
  • TOCIStoredProc: Analog of TStoredProc. It may be used for simplified usage of PL/SQL objects. TOCIQuery can also call PL/SQL. But TOCIStoredProc generate anonymous PL/SQL block and setup parameters automatically.
  • TNCSQLMonitorClient: Client of Borland's SQLMonitor. It may be used to enable NCOCI8 to trace their work into Borlands SQL Monitor.
  • TOCIUpdateSQL: Analog of TUpdateSQL. It may be used for fine grain tune of editing capabilities of TOCIQuery.
  • TOCISequence: Interface to Oracle's sequences.
  • TOCINestedDataSet: Analog of TNestedTable.
  • TOCIImpHndlDatabase: Connection sharing with other TOCIDatabase (DLL).
  • TOCIBDEDatabase: Connection sharing with BDE.
Also 5 companion components:
  • TNCTimer: Multithreaded timer.
  • TNCDBTreeView: NCOCI8 based SQL drived DB treeview.
  • TNCCompNamer: Rule based components namer.
  • TNCDblListBox: Doubled list box.
  • TNCMemoDialog: Dialog for memo editing.
Also where are expert for component naming. You can find it in Delphi's Edit menu. Help file available. Now library is beta testing, but it is already quite efficient.
Fully functional
Source: Included
Download: CB3 CB4 CB5 CB6 D2005 D2006 D3 D4 D5 D6 D7  Homepage

ODAC - Oracle Data Access Components v.9.6.19SW 4249 - 33008 k 16 Sep 2015
By Devart.

Oracle Data Access Components (ODAC) is a library of components that provides direct access to Oracle database servers from Embarcadero RAD Studio XE8/XE7/XE6/XE5/XE4/XE3/XE2/XE, Embarcadero RAD Studio 2010, CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, Turbo Delphi for .NET Professional, Turbo C++ Professional, Borland Delphi 2005, Borland Delphi 7/6, Borland C++Builder 6, Lazarus 1.2.4 and Free Pascal 2.6.2 for Windows, Mac OS X, iOS, Linux, FreeBSD for 32-bit and 64-bit platforms.

ODAC offers wide coverage of the Oracle feature set, supports both Client and Direct connection modes and emphasizes optimized data access strategies. The capability to develop applications using the cutting-edge IDE for all the supported target-platforms: Win32, Win64, Mac OS, iOS, and now - Android. ODAC gives its users an opportunity to establish Direct Connection and get the fastest data access to Oracle databases.

Key Features:

  • Android application development support
  • iOS development support
  • NEXTGEN compiler support
  • Mac OS X development support
  • Win64 development support
  • Direct access to server data. No need to install of other data provider layers
  • VCL, LCL and FMX versions of library available
  • In Direct mode does not require Oracle client software and works directly through TCP/IP
  • Full support of the latest versions of Oracle and its data types
  • Disconnected Model with automatic connection control for working with data offline
  • Local Failover for detecting connection loss and implicit re-execution of certain operations
  • Automatic data updating with the TOraQuery, TSmartQuery, and TOraTable components
  • Advanced script execution functionality with the TOraScript component
  • Integration with OraDeveloper Tools and dbForge Studio for Oracle for advanced database development
  • Oracle Advanced Queuing support
  • Oracle alerts and pipes support
  • Oracle direct path interface support

Trial (work while IDE is running)
Source: On purchase/registration
Price: $149.95
Source Price: $449.95
Download: C2k10 C2k6 C2k7 C2k9 CB-10 CB6 CBXE CBXE2 CBXE4 CBXE5 CBXE6 CBXE7 CBXE8 D-10 D2006 D2007 D2009 D2010 D6 D7 DXE DXE2 DXE4 DXE5 DXE6 DXE64 DXE7 DXE8 FM  Register NowHomepage

Orange Component Set v.1.0 bFWS 86 k 09 Aug 2000
By Above Software. Orange - components for access data on Oracle Server using client version 8.0 or above. Five native Delphi components for accessing and manipulating data on Oracle server:
  • ToSession - To establish Oracle session and transaction control.
  • ToQuery - Used as DataSet by DB-Aware components, execute DDL and DML statements, PL/SQL blocks. Supports all Delphi-compatible Oracle data types, including LOB objects, array parameters and REF cursors.
  • ToProcedure - to easy and fast access to stored procedure on server without writing SQL statement.
  • ToSQLMon - Borland SQL Monitor client.
  • ToSessionControl - Tuning Oracle session: to change current schema, transaction isolation level, enable/disable SQL tracing, set NLS parameters.
Contains SQL script to create tables, procedures and packages for running samples.
Fully functional
Source: Included
Download: D3 D4 D5  Homepage

QueryProc v.2.0FWS 13 k 11 Dec 2000
By Green House multimedia. Improved version that will interact with all servers. Instead of having 4 components to operate a database (TQuery, 2xTStoredProc and TUpdateSQL) use only one TQueryProc to do all job. Component is fast and reliable.
Fully functional
Source: Included
Download: D4 D5  Homepage

TOraSession, TOraDataSet v.0.02FWS 13 k 02 Jun 1999
By Albert A. Mavrin. Two components for access to Oracle (v7.3+) via Oracle Call Interface without BDE. It allows to use any standard data aware controls. Support Parameters, Lookup and Calculate Fields. TOraDataSet can only read data.
Fully functional
Source: Included
Download: CB4 D4  Homepage

Vlad Karpov Native Link to Oracle FWS 75 - 273 k 28 May 2002
By Vlad Karpov. Direct Oracle Access via OCI. Components To8Session, To8Statment, To8DataSet, To8ReadOnlyDataSet, To8DataSet2Oracle.
Fully functional
Source: Included
Download: D4 D5 D6  Discuss productHomepage

News from our Sponsors

  Bring fresh look to your applications!
ThemeEngine is a library of components which allows to change visual appearance and behavior of your application with use of the powerful set of tools including visual components, convenient designers, easy-to-use non-visual components, the optimized graphic algorithms and a set of ready themes. ThemeEngine can add themes to forms, to the menu and to the elements of the management. 150+ stable easy to use components and 1000+ free skins. more... more...

  Coding in Delphi
Coding in Delphi is a new programming book by Nick Hodges that covers a variety of powerful Delphi programming features and techniques including Generics, Interfaces, Exception, Handling, Anonymous Methods, Collections, RTTI, Enumerators, Attributes, Dependency Injection and Unit Testing more... more...

Advertising on Torry's Delphi Pages


Sort order
Quick Search
Exact phrase

Advertising on Torry's Delphi Pages

Guest Book
Guest Book

Subscribe to news in RSS 2.0 format!Subscribe to news in RSS 2.0 format!
Bookmark and Share
Up | Home | 10% - Off! | New | VCL | DB-Aware | Tools | DB Tools | Apps | Samples | .NET | .NET DB-Aware | .NET Tools | .NET Samples | Kylix | Docs | Bold | Discussion | Sites | Tips | DPFL | Authors | Uploads | RSS | Store | Advertisement | About
Copyright © Torry's Delphi Pages Torry's Delphi Pages Notes? Comments? Feel free to send...

The Ultimate Source of Object Pascal and Delphi Programming Knowledge.

Copyright © 1996-2015
All trademarks are the sole property of their respective owners
Privacy Policy