CREATE PACKAGE v17
Name
CREATE PACKAGE — Define a new package specification.
Synopsis
CREATE [ OR REPLACE ] PACKAGE <name> [ AUTHID { DEFINER | CURRENT_USER } ] { IS | AS } [ <declaration>; ] [, ...] [ { PROCEDURE <proc_name> [ (<argname> [ IN | IN OUT | OUT ] <argtype> [ DEFAULT <value> ] [, ...]) ]; [ PRAGMA RESTRICT_REFERENCES(<name>, { RNDS | RNPS | TRUST | WNDS | WNPS } [, ... ] ); ] | FUNCTION <func_name> [ (<argname> [ IN | IN OUT | OUT ] <argtype> [ DEFAULT <value> ] [, ...]) ] RETURN <rettype> [ DETERMINISTIC ]; [ PRAGMA RESTRICT_REFERENCES(<name>, { RNDS | RNPS | TRUST | WNDS | WNPS } [, ... ] ); ] } ] [, ...] END [ <name> ]
Description
CREATE PACKAGE defines a new package specification. CREATE OR REPLACE PACKAGE either creates a new package specification or replaces an existing specification.
If you include a schema name, then the package is created in the specified schema. Otherwise it's created in the current schema. The name of the new package can't match any existing package in the same schema unless you want to update the definition of an existing package. In that case, use CREATE OR REPLACE PACKAGE.
The user that creates the procedure becomes the owner of the package.
Parameters
name
The name (optionally schema-qualified) of the package to create.
DEFINER | CURRENT_USER
Specifies whether to use the privileges of the package owner (DEFINER) or the privileges of the current user executing a program in the package (CURRENT_USER) to determine whether access is allowed to database objects referenced in the package. DEFINER is the default.
declaration
A public variable, type, cursor, or REF CURSOR declaration.
proc_name
The name of a public procedure.
argname
The name of an argument.
IN | IN OUT | OUT
The argument mode.
argtype
The data types of the program’s arguments.
DEFAULT value
Default value of an input argument.
func_name
The name of a public function.
rettype
The return data type.
DETERMINISTIC
DETERMINISTIC is a synonym for IMMUTABLE. A DETERMINISTIC procedure can't modify the database and always reaches the same result when given the same argument values. It doesn't perform database lookups and uses only information directly present in its argument list. If you include this clause, you can immediately replace any call of the procedure with all-constant arguments with the procedure value.
RNDS | RNPS | TRUST | WNDS | WNPS
The keywords are accepted for compatibility and ignored.
Examples
The package specification empinfo contains three public components: a public variable, a public procedure, and a public function:
CREATE OR REPLACE PACKAGE empinfo IS emp_name VARCHAR2(10); PROCEDURE get_name ( p_empno NUMBER ); FUNCTION display_counter RETURN INTEGER; END;