|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
Packages are defined using PL/SQL. Therefore, this section provides some general information but refers to Oracle Database PL/SQL Language Reference for details of syntax and semantics.
PACKAGE statement to create the specification for a stored package, which is an encapsulated collection of related procedures, functions, and other program objects stored together in the database. The package specification declares these objects. The package body, specified subsequently, defines these objects.
CREATE PACKAGE BODY for information on specifying the implementation of the package
Oracle Database Advanced Application Developer's Guide and Oracle Database PL/SQL Packages and Types Reference for detailed discussions of packages and how to use them
To create or replace a package in your own schema, you must have the
PROCEDURE system privilege. To create or replace a package in another user's schema, you must have the
PROCEDURE system privilege.
To embed a
PACKAGE statement inside an Oracle Database precompiler program, you must terminate the statement with the keyword
END-EXEC followed by the embedded SQL statement terminator for the specific language.
See Also:Oracle Database PL/SQL Language Reference for more information
Packages are defined using PL/SQL. Therefore, the syntax diagram in this book shows only the SQL keywords. Please refer to Oracle Database PL/SQL Language Reference for the PL/SQL syntax, semantics, and examples.
plsql_source: See Oracle Database PL/SQL Language Reference.)
REPLACE to re-create the package specification if it already exists. Use this clause to change the specification of an existing package without dropping, re-creating, and regranting object privileges previously granted on the package. If you change a package specification, then Oracle Database recompiles it.
Users who had previously been granted privileges on a redefined package can still access the package without being regranted the privileges.
If any function-based indexes depend on the package, then the database marks the indexes
PACKAGEfor information on recompiling package specifications
See Oracle Database PL/SQL Language Reference for the syntax and semantics of the
plsql_source, including examples.