Complete execution environment for stored programs

Using SQL Navigator, you can —

 browse program structures

 view and edit the source code of all program units

 compile the code

 set input parameters

 run the program

 watch the results in the output window.

The Stored Program Editor—which you use to edit PL/SQL and other program code—includes a Code Explorer tool that helps make your work with packages, procedures, and functions more efficient and error-free.

The Code Explorer:

 is based on an advanced parsing technique that understands PL/SQL syntax.

 displays detailed information about a package’s components, such as variables and parameters, their types, structure and cursors.

 automatically highlights the packaged procedure you are currently in

 supports drag-and-drop into the editor

 combines information from the specification and body

 highlights syntax

 distinguishes non-published procedures and functions with a different icon

 lets you quickly jump between the implementation and declaration of the current procedure in a package (Ctrl+Shift+up arrow and Ctrl+Shift+down arrow).

 lets you quickly jump between the between the specification and the body (Alt+F11).

 You can start a stored program from the SQL Editor, the DB Navigator or the Stored Program Editor.

 You can develop and debug PL/SQL code, prepare test data, run stored programs against the database, and immediately view the results. Compilation errors are precisely highlighted

 Flexible editing and processing let you single step through code, skip, rewind, and other editing functions.

 Drag-and-drop features let you drag and drop PL/SQL syntax, SQL functions, column names, and database object names into code. The Code Assistant provides easy access to code snippets, drag and drop syntax, and the PL/Vision catalogs.

 Using the Debug Mode, you can watch the result values during runtime. You can run stored programs in parallel by opening additional sessions within SQL Navigator.

 The Execution Console and integrated PL/SQL debugging tools help you create anonymous PL/SQL blocks that call stored programs.

 SQL Navigator integrates with Formatter Plus, a unique utility for reformatting existing PL/SQL, SQL*Forms, Oracle Forms, and SQL*Plus source code. Formatter Plus hyper-fast reformatting instantly improves the maintainability of code by advanced analysis and profiling methods

 You can define bookmarks and easily move between them within a large program.

 You have the option to automatically compile all dependent objects when saving an object using the object editor. This eliminates the need to find and compile all dependent objects that became invalid when altering a procedure, table, or other structure.

 The integrated Output window is convenient for testing and debugging, with Save and Print options. It allows up to 100,000 lines of output to be displayed, and eliminates the need to switch to another tool to test your stored programs. The Output window can be made a dockable, stay-on-top window or a normal MDI window by means of a shortcut menu option.

 You can correct errors easily with virtually unlimited levels of Undo and Redo functions.

 Customized color selection for PL/SQL and SQL keywords, text and comments makes code more readable.

 You can save time by using programmable keys and hotkeys for frequently used PL/SQL code, including multi-line segments.

 To view a fully expanded Oracle error description, you can double-click on an error code in any of the editors, or in the Output window. The resulting dialog contains the error message description, cause and actions, just as they appear in the Oracle documentation.

 The HTML Import capability lets you easily convert an HTML file into a PL/SQL stored procedure. The stored procedure will in turn output the HTML code via the Oracle Web Cartridge.