CREATE PACKAGE

The CREATE PACKAGE statement is used to create or replace the package header for stored procedures.

A package is a collection of related stored procedures, functions, and other program objects stored as a unit in the database. The package header first declares these objects and then specifies the package body that defines them.

Prerequisites

To create or replace a package in your schema, you must have the CREATE PACKAGE system privilege. To create or replace a package in another user's schema, you must have the CREATE ANY PACKAGE system privilege.

Syntax

The syntax of create_package is as follows:

CREATE [ OR REPLACE ]
PACKAGE plsql_package_source

where:

• The syntax of plsql_package_source is as follows:

  [ schema. ] package_name [ sharing_clause ] [ { default_collation_clause | invoker_rights_clause | accessible_by_clause }... ]
  { IS | AS } package_item_list END [ package_name ] ;
  

• The syntax of package_item_list is as follows:

  { type_definition
  | cursor_declaration
  | item_declaration
  | package_function_declaration
  | package_procedure_declaration }
  ...
  

• The syntax of package_function_declaration is as follows:

  function_heading
  [ accessible_by_clause
  | determinitic_clause
  | pipelined_clause
  | parallel_enable_clause
  | result_cache_clause ] ;
  

• The syntax of package_procedure_declaration is as follows:

  procedure_heading [accessible_by_clause] ;
  

Semantics

Examples

Create a package named obdemo_pack that contains a record variable obDeptRec, two functions, and a stored procedure.

CREATE OR REPLACE PACKAGE obdemo_pack
    IS
        obDeptRec obdept%ROWTYPE;
        FUNCTION add_obdept(dept_no NUMBER, dept_name VARCHAR2, location VARCHAR2)
          RETURN NUMBER;
        FUNCTION remove_obdept(dept_no NUMBER)
            RETURN NUMBER;
        PROCEDURE query_obdept(dept_no IN NUMBER);
    END obdemo_pack;
    /