Physical Modeling › Oracle Physical Property Editors › Oracle Package Editor

Oracle Package Editor

Use the Oracle Package Editor to create new packages or edit package properties such as package specification, body, synonyms and so on.

Open the Oracle Package Editor by selecting Package from the Database menu.

For Oracle 9i and 10g, packages are supported in the following features:

• Forward Engineering
• Reverse Engineering

The Oracle Package Editor dialog includes the following tabs:

Comment Add or edit comments for a package.

Specification Enter or edit package specifications such as stored procedures or functions.

Body Enter or edit the package body.

Expanded Displays expanded code for the package body and package specification in read-only format.

Synonym Enter or edit synonyms for a package.

Context Enter or edit a context for a package.

Object Creation Order Specify the order of creation for procedures, functions, and packages.

UDP Enter user-defined property values for a package.

The following describes all of the other options available in this dialog:

• Packages

  A list box that contains the packages available in the current model.

• Owner

  You can enter a name in this text box to assign a database Owner to the selected package.

• New

  Opens the Create Package dialog where you can specify the name for the new package.

• Rename

  Opens the Rename Package <Package Name> dialog where you can assign a different name to the selected package.

• Delete

  Select a package from the Packages list box that you want to delete, and click the Delete button.

• Generate

  Select this check box if you want to generate DDL for this object during Forward Engineering. If you do not select the check box, no DDL will be generated for this object during Forward Engineering.

• Create or Replace

  Select this check box if you want the package DDL that is generated during Forward Engineering to replace any occurrence of an identically-named package. If this check box is not selected, the package DDL generated will only attempt to create the object and will not attempt to replace it.

• DB Sync

  Starts the Complete Compare task so you can synchronize the physical objects defined in your model with the information stored on the server.