OraDeveloper Tools for Delphi 2.55.148

OraDeveloper Tools is a set of IDE add-ins designed to automate and simplify the process of developing applications with Oracle from Delphi. This version of OraDeveloper Tools integrates directly into Borland Development Studio and provides an easier way for application developers to browse databases, modify schema objects, update data, visually design queries, and develop SQL scripts and PL/SQL program units.

All components interact with existing editors and Database Explorer for streamlined database navigation and development.

OraDeveloper Tools package extensions are available for Borland Developer Studio 2005, Borland Developer Studio 2006, Gode Gear Delphi 2007 for Win32. OraDeveloper Tools for Delphi does not require client software and works with Oracle 8.0, 8i, 9i and 10g.

Major Features:

1. Full development environment integration
   • All database development and administration tasks available from your favorite IDE
   • SQL Editor, database object editors and other editors behave like usual IDE documents
   • Help integrated into Microsoft Visual Studio .NET and Borland Delphi
2. Component designers' extended capabilities
   • New verbs to access useful features
   • SQL Editor, Query Builder, all of Object Editors to facilitate your work
3. Convenient Server Browsing
   • Multiple simultaneous connections
   • Quick invocation of object editors
   • Single-click access to object properties
   • Full object search
   • Dynamic data viewing
   • Database object dependency support
   • Browsing history
4. Easy Database Object Manipulation
   • Convenient and easily accessible visual editors for all objects
   • Visual design and text modes
   • Generatable DDL scripts for database objects
   • Duplication of database objects
   • Changes are cached until you apply them
   • Comment support for tables, views, materialized views, table and view columns
   • Undo option
5. Database Project Support
   • Project Explorer workspace for organizing related database objects and scripts into a single project
   • Easy project deployment
   • Workspace saving
   • Convenient document control
   • Project PL/SQL programs compilation
   • Ability to export an entire project into a file
   • Ability to export a project into an SQL*Plus script
6. Enhanced SQL Editor
   • Syntax highlighting
   • Context-sensitive code completion and parameter information
   • Mouseover quick info for database objects
   • Code outlining integrated with navigatable Document Outline panel
   • Extensive collection of SQL code templates
   • Storage of all executed queries in full history log
   • Quick SQL history navigation
   • Display of created database objects and subobjects on SQL file Navigation bar
   • Code Bookmark support
7. PL/SQL and Script Debugging
   • Debugging of stored procedures and functions, object types, packages, triggers, and SQL scripts
   • Step into, step over, run to cursor and breakpoint support
   • Support for evaluating and modifying variables
   • Navigatable Call Stack
8. Advanced Database Administration Tools
   • Security Manager for manipulating users, roles, user profiles and privileges
   • Session Manager for controlling sessions
   • Event Monitor for watching and sending Oracle alerts and pipe messages
9. Visual Query Builder
   • Powerful interactive query construction
   • No need to type a line of code to compose a query
   • Visual creation of all types of JOINs
   • Advanced tabbed editor with full SELECT statement clause support
   • Integration with Database Explorer
10. Extended SQL Execution Features
    • Support of the following SQL*Plus commands: @, @@, ACCEPT, CLEAR, CONNECT, DEFINE, DESCRIBE, EXECUTE, PROMPT, REMARK, VARIABLE
    • Execution of files, stored procedures and functions, and selected code fragments
    • Analysis of query performance with the Plan tool
    • Script support
    • Asynchronous execution
11. Powerful Grid-Based Data Editor
    • Highly customizable
    • In-place filtering, sorting, and grouping
    • Paginal mode
    • Separate LOB Editor for viewing and updating simple binary objects and long text
    • Transaction mechanism for data manipulation control
    • Client-side caching
    • Data printing
    • Graphic card view
12. Easy Data Export
    • Support of Text, HTML, XML, and MS Excel file formats
    • Customizable export document appearance attributes
    • Export of entire grid or selected rows and columns
13. Database Export/Import
    • Based on native Oracle Exp and Imp utilities
    • Friendly user interface
    • Different export modes
    • Advanced database import features
14. Customizable Schema Export/Import to/from SQL
    • Extracting of any supported schema object
    • Data extracting from selected or all tables
    • Different extracting options
    • Advanced schema import features
15. User-friendly Object Editor for Every Supported Schema Object
    • Table
    • View
    • Index
    • Unique key
    • Foreign key
    • Check constraint
    • Package
    • Stored procedure
    • Stored function
    • Trigger
    • User type
    • Sequence
    • Materialized view
    • Materialized view log
    • Synonym
    • Cluster
    • Database link
    • XML schema
16. Flexible Connectivity
    • Support for all Oracle versions from 7.3 to 11g
    • Ability to use several Oracle Homes in single application
    • Instant Client support
    • Optional direct access mode for establishing connections without Oracle client software
17. Convenient and flexible user interface
    • Tabbed documents
    • Documents with different views
    • Documents tab groups
    • Highly customizable layout
    • Dockable tool windows with auto hide and floating
    • Customizable toolbars
18. Comprehensive help system
    • Context help for every window and tab
    • Detailed reference for every OraDeveloper component
    • Tutorials that help you get started quickly

Enhancements:

• The problem with accessing to a disposed object on closing application was fixed
  
• IndexOutOfRange exception on retrieving table metadata was fixed
  
• Inserting NUMBER or VARCHAR values in Data Editor in Direct mode is working correctly now
  
• NullReferenceException on showing watermark on printing contents of Data Editor was fixed
  
• NotSupportedException on showing data of tables with RAW fields was fixed
  
• Incorrect opening of a file in LOB Editor was fixed
• ArgumentOutOfRangeException on navigating in Object View was fixed
  
• Views duplication on refreshing in Database Explorer after renaming them was fixed
  
• Incorrect work with DATA paramteres was fixed