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, Code, and Security. The SQL tab displays the SQL code generated by dialog selections.
Use the fields in the General tab to identify the package:
Click the Code tab to continue.
Use the fields in the Code tab to specify the package contents and to provide implementation details:
Click the Security tab to continue.
Use the fields in the Security tab to to assign EXECUTE privileges for the package to a role. Click the Add icon (+) to set privileges for the package:
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:
The example shown demonstrates creating a package named empinfo that includes one function and one procedure.