A procedure or function is a set of SQL or PL/SQL statements that perform a specific task. A package is a group of related functions, procedures, cursors, and variables. For information about stored procedures, functions, and packages, see the Oracle7 Server Concepts and the Oracle7 Server Application Developer's Guide. For information on PL/SQL, see the PL/SQL User's Guide and Reference.
The following figure illustrates the Packages object list.
Figure 7 - 3. Package Object List
Name | Object owner and name of the object. |
Type | Type of object: Function, Package, Package Body, or Procedure. |
Status | Status of the object: Valid or Invalid (needs to be recompiled). |
Modified | Date the object was last modified as the result of a DDL (Data Definition Language) command, including GRANT and REVOKE. |