| Oracle Data Access Components Features |
- General usability
- Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
- Interface compatible with standard data access methods, such as BDE and ADO
- VCL, VCL for .NET, and CLX versions of library available
- Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
- Unicode and national charset support
- Network and connectivity
- In Direct mode does not require Oracle client software and works directly through TCP/IP
- Disconnected Model with automatic connection control for working with data offline
- Local Failover for detecting connection loss and implicitly reexecuting certain operations
- Support for setting connection timeout values for Direct mode
- Compatibility
- Full support of the latest versions of Oracle
- Support for all Oracle data types
- Compatible with all IDE versions starting with Delphi 5, C++Builder 5, and Kylix 2
- Wide reporting component support, including support for InfoPower, ReportBuilder, FastReport
- Support of all standard and third-party visual data-aware controls
- Allows you to use Professional Edition of Delphi and C++Builder to develop client/server applications.
- Oracle technology support
- Oracle Advanced Queuing support
- Distributed transactions support with TOraTransaction component
- Oracle package support
- Support for Oracle alerts and pipes with TOraAlerter component
- Support for Direct Path interface with TOraLoader component
- Support for DBMS_TRACE package and SQLTrace functionality with TOraTrace
- Support for Oracle Change notifications functionality of Oracle 10g with TOraChangeNotification component
- Oracle Transparent Application Failover support
- Oracle 9i scrollable cursor support
- Multiple Oracle Homes support
- Oracle sequence support
- DML array operations support
- Direct lob access support
- Temporary LOB management routines
- Temporary LOBs for updating LOB fields
- OCI Connection Pooling, Proxy Session Pooling, and Statement Caching
- Oracle optimizer control
- ProxySession support
- External Procedure support
- CLIENT_IDENTIFIER support
- Oracle data types
- Oracle Object (including NOT FINAL objects) types support
- Nested table support
- PL/SQL table support
- XMLTYPE datatype support
- Oracle 9i TIMESTAMP and INTERVAL data types support
- Performance
- High overall performance
- Fast controlled fetch of large data blocks
- Optimized string data storing
- Advanced connection pooling
- High performance of applying cached updates with batches
- Caching of calculated and lookup fields
- Expanded fields in TSmartQuery
- Fast Locate in a sorted DataSet
- Preparing of user-defined update statements
- Local data storage operations
- Database-independent data storage with TVirtualTable component
- CachedUpdates operation mode
- Local sorting and filtering, including by calculated and lookup fields
- Local master/detail relationship
- Master/detail relationship in CachedUpdates mode
- Data access and data management automation
- Automatic data updating with TOraQuery, TSmartQuery and TOraTable components
- Automatic record refreshing and locking
- Automatic query preparing
- SmartRefresh option allows you to synchronize two or more datasets automatically
- Support for ftWideMemo field type in Delphi 2006 and higher
- Extended data access functionality
- Separate component for executing SQL and PL/SQL blocks
- Simplified access to table data with TOraTable component
- BLOB compression support
- Support for using macros in SQL
- NonBlocking mode allows background executing and fetching data in separate threads
- Ability to customize update commands by attaching external components to TOraUpdateSQL objects
- Deferred detail DataSet refresh in master/detail relationships
- LargeInt fields support
- MIDAS technology support
- OraDataAdapter component for WinForms and ASP.NET applications
- Ability to customize Oracle error messages with TOraErrorHandler
- Data exchange
- Transferring data between all types of TDataSet descendants with TCRBatchMove component
- Data export and import to/from XML (ADO format)
- Ability to synchronize positions in different DataSets
- Script execution
- Advanced script execution features with TOraScript component
- Support for executing individual statements in scripts
- Support for executing huge scripts stored in files with dynamic loading
- Ability to use standard SQL*Plus tool syntax in scripts
- SQL Execution monitoring
- Extended SQL tracing capabilities provided by TOraSQLMonitor component and DBMonitor
- Borland SQL Monitor support
- Ability to send messages to DBMonitor from any point in your program
- Visual extensions
- Includes source code of enhanced TCRDBGrid data-aware grid control
- Customizable connection dialog
- Cursor changes during non-blocking execution
- Design-time enhancements
- DataSet Manager tool to control DataSet instances in the project
- Oracle Package Wizard that simplifies working with PL/SQL Packages
- Advanced design-time component and property editors
- Integration with OraDeveloper Tools for browsing database schemas, manipulating database objects and visual building of queries
- Automatic design-time component linking
- OraTools Add-in extends design-time capabilities and lets you build and test queries, design and debug PL/SQL blocks and explore database schemas
- Easy migration from BDE with Migration Wizard
- More convenient data source setup with the TOraDataSource component
- Syntax highlighting in design-time editors
- Product clarity
- Complete documentation sets
- Printable documentation in PDF format
- A large amount of helpful demo projects
- Licensing and support
- Included annual ODAC Subscription with Priority Support
- Licensed royalty-free per developer, per team, or per site
|
|
|
