A package is a database object that groups logically related PL/SQL types, items, functions and procedures. You can create, view, edit, compile, drop, download a package, and view a report.
Packages usually have two parts, a specification and a body. The specification is the interface to your application. The body implements the specification.
See Also:
"Using PL/SQL Packages " in Oracle Database PL/SQL Language Reference for additional information on PL/SQL packages.
"Using PL/SQL Subprograms" in Oracle Database PL/SQL Language Reference for information on PL/SQL subprograms
Create a package using Object Browser. Select the type of package you want to create.
To create a package:
Select a package from the Object Selection pane and view different reports about the package.
When you access a package in Object Browser the specification appears.
To view a specification:
Alternative views available when viewing a package in Object Browser.
Table 2-7 describes all available reports for packages.
Table 2-7 Available Reports for Packages
Select a package from the Object Selection pane and click Find or Replace.
When you edit a package, you can edit the code manually, perform a search and replace, and compile the package.
If you edit and make changes to a view, you must compile to save your changes.
There is no save function because this is just a view of the object within the database.
To compile a package:
Select a package from the Object Selection pane and download a package by clicking Download Source to save the current package as a file.
To download a package:
Select a package from the Object Selection pane and click Drop.
To drop a package while viewing the Specification: