包（pl/sql）

创建包：

 create or replace package jiaoxue_package is
    function display_grade(v_sno number, v_cno number) return number;
    procedure app_departmen(v_id      number,
                            v_name    varchar2,
                            v_address varchar2);
  end jiaoxue_package;

定义包体

create or replace package body jiaoxue_package is
    function display_grade(v_sno number, v_cno number) return number as
      v_score students_grade.score%type;
    begin
      select score
        into v_score
        from students_grade
       where student_id = v_sno
         and course_id = v_cno;
      return v_score;
    exception
      when no_data_found then
        dbms_output.put_line('该生或该门课程部存在');
    end display_grade;
    procedure app_departmen(v_id      number,
                            v_name    varchar2,
                            v_address varchar2) as
    begin
      insert into departments values (v_id, v_name, v_address);
    exception
      when dup_val_on_index then
        dbms_output.put_line('插入系部信息时，系部号不能重复。');
    end app_departmen;
  end jiaoxue_package;

调用包

execute jiaoxue_package.display_grade(110,111);

查看包信息同查看函数信息 (查看视图user_objects,user_source)
show error 来查看错误
edit 来编辑修改
drop package body package_name;  删除包体
drop package package_name;    删除包及包体;
重载用 创建时用or replace 即可