The interactions in this eCourse require Javascript to be enabled.
Creating the Package Specification
previous|next
Package Specification Syntax To create packages, you declare all public constructs in the package specification.
Specify the OR REPLACE option, if overwriting an existing package specification. Initialize a variable with a constant value or formula within the declaration, if required; otherwise, the variable is initialized implicitly to NULL. The package specification should contain procedure and function headings terminated by a semicolon, without the IS (or AS) keyword and its PL/SQL block. The implementation of a procedure or function that is declared in a package specification is done in the package body.
CREATE [OR REPLACE] PACKAGE package_name IS|AS public type and variable declarations subprogram specificationsEND [package_name]
Example
CREATE OR REPLACE PACKAGE hr_pack IS PROCEDURE raise_salary (p_id IN employees.employee_id%TYPE, p_percent IN NUMBER); FUNCTION get_sal (p_id IN employees.employee_id%TYPE) RETURN NUMBER;END hr_pack;