| |
Connection to Oracle Database from Delphi, C++Builder, and Lazarus Oracle Data Access Components (ODAC) is a library of components that provides native connectivity to Oracle from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. The ODAC library is designed to help programmers develop faster and more native Oracle database applications.
ODAC, a high-performance and feature-rich Oracle connectivity solution, is an efficient native alternative to the Borland Database Engine (BDE) and standard dbExpress driver. It provides both possibilities of connection to Oracle through native Oracle data access and direct Oracle access from Delphi without Oracle Client.
|
|
Features
|
Standard
|
Professional
|
 |
Direct Connectivity
|
|
|
|
Connection without Oracle client
|
|
ⅴ
|
|
|
|
|
 |
Desktop Application Development
|
|
|
|
Windows
|
ⅴ
|
ⅴ
|
|
macOS
|
|
ⅴ
|
|
Linux
|
|
ⅴ
|
|
|
|
|
 |
Mobile Application Development
|
|
|
|
iOS
|
|
ⅴ
|
|
Android
|
|
ⅴ
|
|
|
|
|
 |
Data Access Components
|
|
|
|
Base components
|
ⅴ
|
ⅴ
|
|
TOraSession
|
|
|
|
TOraQuery
|
|
|
|
TOraTable
|
|
|
|
TOraStoredProc
|
|
|
|
TOraUpdateSQL
|
|
|
|
TOraSQL
|
|
|
|
TOraDataSource
|
|
|
|
Script executing
|
ⅴ
|
ⅴ
|
|
TOraScript
|
|
|
|
Transactions managing
|
|
ⅴ
|
|
TOraTransaction
|
|
|
|
Fast data loading into the server
|
|
ⅴ
|
|
TOraLoader
|
|
|
|
|
|
|
 |
Advanced Query Component
|
|
|
|
Expanded field representation
|
ⅴ
|
ⅴ
|
|
TSmartQuery
|
|
|
|
Smart refresh in TSmartQuery component
|
|
ⅴ
|
|
|
|
|
 |
Oracle Specific Components
|
|
|
|
Oracle packages
|
|
ⅴ
|
|
TOraPackage
|
|
|
|
Oracle nested tables
|
ⅴ
|
ⅴ
|
|
TOraNestedTable
|
|
|
|
Messaging between sessions and applications
|
|
ⅴ
|
|
TOraAlerter
|
|
|
|
Reaction on server side changes on-the-fly
|
|
ⅴ
|
|
TOraChangeNotification
|
|
|
|
Oracle advanced queing
|
|
ⅴ
|
|
TOraQueue
|
|
|
|
TOraQueueAdmin
|
|
|
|
TOraQueueTable
|
|
|
|
PL/SQL tracing
|
|
ⅴ
|
|
TOraTrace
|
|
|
|
Obtaining metadata about database objects
|
|
ⅴ
|
|
TOraMetaData
|
|
|
|
Oracle errors handling
|
|
ⅴ
|
|
TOraErrorHandler
|
|
|
|
|
|
|
 |
Database Activity Monitoring
|
|
|
|
Monitoring of per-component SQL execution
|
ⅴ
|
ⅴ
|
|
TOraSQLMonitor
|
|
|
|
|
|
|
 |
Additional Components
|
|
|
|
Advanced connection dialog
|
ⅴ
|
ⅴ
|
|
TConnectDialog
|
|
|
|
Data encryption and decryption
|
|
ⅴ
|
|
TOraEncryptor
|
|
|
|
Advanced DataSet provider
|
|
ⅴ
|
|
TOraProvider
|
|
|
|
Data storing in memory table
|
ⅴ
|
ⅴ
|
|
TVirtualTable
|
|
|
|
Dataset that wraps arbitrary non-tabular data
|
ⅴ
|
ⅴ
|
|
TVirtualDataSet
|
|
|
|
Advanced DBGrid with extended functionality
|
ⅴ
|
ⅴ
|
|
TCRDBGrid
|
|
|
|
Records transferring between datasets
|
|
ⅴ
|
|
TCRBatchMove
|
|
|
|
|
|
|
 |
Design-Time Features
|
|
|
|
Enhanced component and property editors
|
ⅴ
|
ⅴ
|
|
Migration Wizard
|
ⅴ
|
ⅴ
|
|
DataSet Manager
|
|
ⅴ
|
|
Oracle Package Wizard
|
|
ⅴ
|
|
|
