Online Documentation for SQL Manager for Oracle

Creating/editing package

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



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



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


The lower area of the editor window allows you to specify the package definition, which can contain type definitions, cursor declarations, variable declarations, constant declarations, exception declarations, PL/SQL subprogram specifications, and 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 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 Editor - Editing package definition


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