Online Documentation for SQL Manager for Oracle

Creating/editing package body

Use the Package Body tab of Package Body Editor to create/edit the specification of a package body.



Specify the name of the package body to be created, or view the name of the package body being edited. Note that the package body name must be unique within its schema.



Use the drop-down list to specify the schema in which the package body will be created.


The lower area of the editor window allows you to specify the package body definition, which can contain PL/SQL subprogram bodies or call specifications, which are declarations of a C or Java routine expressed in PL/SQL. The DDL tab will display the changes made to the package body specification.


For your convenience the code folding, syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with Query data editor and Using the context menu.


Package Body Editor - Editing Package Body definition


To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.