Package Dialog

Use the Package dialog to create a (user-defined) package specification.

The Package dialog organizes the management of a package through the following dialog tabs: General, Header, Body, and Security. The SQL tab displays the SQL code generated by dialog selections.

Package dialog general tab

Create Package dialog - General tab

Use the fields in the General tab to identify the package:

  • Use the Name field to add a descriptive name for the package. The name of a new package must not match any existing package in the same schema.

  • Select the schema in which the package will reside from the drop-down listbox in the Schema field.

  • Store notes about the package in the Comment field.

Click the Header tab to continue.

Package dialog header tab

Create Package dialog - Header tab

Use the Header field to define the public interface for the package.

Click the Body tab to continue.

Package dialog body tab

Create Package dialog - Body tab

Use the Body field to provide the code that implements each package object.

Click the Security tab to continue.

Package dialog security tab

Create Package dialog - Security tab

Use the fields in the Security tab to assign EXECUTE privileges for the package to a role. Click the Add icon (+) to set privileges for the package:

  • Select the name of the role from the drop-down listbox in the Grantee field.

  • Click inside the Privileges field. Check the boxes to the left of a privilege to grant the selected privilege to the specified user.

  • The current user, who is the default grantor for granting the privilege, is displayed in the Grantor field.

Click the Add icon (+) to assign additional privileges; to discard a privilege, click the trash icon to the left of the row, and confirm the deletion in the Delete Row popup.

Click the SQL tab to continue.

Your entries in the Package dialog generate a SQL command that creates or modifies a package definition:

Package dialog sql tab

Create Package dialog - SQL tab

The example shown demonstrates creating a package named empinfo that includes two function and two procedure.

  • Click the Save button to save work.

  • Click the Cancel button to exit without saving work.

  • Click the Reset button to delete any changes to the dialog.