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;
这个是必须的
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |