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;