3.3.21 CREATE PACKAGE

Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.21 CREATE PACKAGE

CREATE PACKAGE -- define a new package specification
[ declaration; ] [, ...]
[ (argname [ IN | IN OUT | OUT ] argtype [ DEFAULT value ]
FUNCTION func_name
[ (argname [ IN | IN OUT | OUT ] argtype [ DEFAULT value ]
RETURN rettype;
END [ name ]
CREATE PACKAGE defines a new package specification. CREATE OR REPLACE PACKAGE will either create a new package specification, or replace an existing specification.
See Section 6 for more information about packages.
Specifies whether the privileges of the package owner (DEFINER) or the privileges of the current user executing a program in the package (CURRENT_USER) are to be used to determine whether or not access is allowed to database objects referenced in the package. DEFINER is the default.
The package specification, empinfo, contains three public components - a public variable, a public procedure, and a public function. See the CREATE PACKAGE BODY command for the package body for this example.

3 The SQL Language : 3.3 SQL Commands : 3.3.21 CREATE PACKAGE

Table of Contents Previous Next