EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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.