oracle 包的例子

郑全

create or replace package pkg_emp is
  procedure p_emp;
  function f_emp return number;
end;

 

create or replace package body pkg_emp is
  procedure p_emp as
    int_count number;
  begin
    select count(*) into int_count from v_emp;
  end;
  function f_emp return number is
  begin
    p_emp;
    return 1;
  end;
end;

 

--对包授权:

grant execute on pkg_emp to sztech1;

郑全

这个是必须的